Oracle 数据字典学习

2014-11-24 18:24:52 · 作者: · 浏览: 0

一、静态视图:
select * from dict where table_name like '%SYNONYM%';
select * from DBA_SYNONYMS where table_name='DBA_TABLES';
select * from dba_objects where object_name='DBA_TABLES';
select * from dba_views where view_name='DBA_TABLES';