SQL> select name,referenced_name,referenced_type from sys.dba_dependencies where owner='salary' and name='tablename';
==> inside schema 'jephe', which are the objects table 'tablename' depends on? List name,referenced_name,referenced_type
SQL> select name,type,referenced_type from sys.dba_dependencies where owner='C_UAT' and referenced_name='REPORT_MAP';
==> list which are the objects that refers to object 'REPORT_MAP'.
Showing posts with label dependency. Show all posts
Showing posts with label dependency. Show all posts
Sunday, June 22, 2008
Subscribe to:
Posts (Atom)