Dba_dependencies Query Results View

[[email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.2.0.4.0 Production on Fri Mar 09:11:24 2015Copyrigh  T (c) 1982, Oracle. All rights reserved.  Connected to:oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit productionwith The partitioning, OLAP, Data Mining and Real application testing optionssql> Col owner format a15sql> col name format a15sql> Col referenced_ NAME format a30sql> Col referenced_owner format a16sql> Col referenced_link_name format a30sql> set line 200SQL > select * from Dba_dependencies where NAME is like '%v_sal% '; OWNER NAME TYPE REFERENCE D_owner referenced_name referenced_type referenced_link_name dependency_type---------------- -------------- ------------------ ---------------  ------------------------------ ------------------ ----------------  -----------------------------Scott V_sal VIEW Scott DEPT                         TABLE Hardscott v_sal VIEW          SCOTT EMP TABLE Hardsystem                                              Syn_v_sal synonym SCOTT v_sal VIEW  Hardsql>

Copyright notice: This article Bo Master original articles, blogs, without consent may not be reproduced.

Dba_dependencies Query Results View