|
|
1.
COL OBJECT_NAME FORM A30
COL OBJECT_TYPE FORM A30
select object_name, object_type fromdba_objects where object_name like '%object_name%';
2.
select table_name from dict where table_name like '%object_name%'
dict_columns
3.
select * from tab where tname like '%object_name%'
4. 查询动态视图
select * from v$fixed_table where name like '%object_name%'
5. 查询动态视图的定义
select * from v$fixed_view_definition where view_name like '%object_name%' |
|