Query dba_dependencies
SQL>
SQL> set linesize 132
SQL> column referenced_object format a35
SQL> clear breaks
breaks cleared
SQL> break on name on type
SQL>
SQL> select name,type,referenced_owner ||'.'|| referenced_name referenced_object
2 from dba_dependencies
3 where owner = 'HR'
4 /
NAME TYPE REFERENCED_OBJECT
------------------------------ ----------------- -----------------------------------
UPDATE_JOB_HISTORY TRIGGER SYS.STANDARD
ADD_JOB_HISTORY PROCEDURE SYS.STANDARD
SECURE_DML PROCEDURE SYS.STANDARD
SYS.DBMS_STANDARD
ADD_JOB_HISTORY PROCEDURE SYS.SYS_STUB_FOR_PURITY_ANALYSIS
SECURE_DML PROCEDURE SYS.SYS_STUB_FOR_PURITY_ANALYSIS
EMP_DETAILS_VIEW VIEW HR.REGIONS
HR.COUNTRIES
HR.LOCATIONS
HR.DEPARTMENTS
HR.JOBS
UPDATE_JOB_HISTORY TRIGGER HR.EMPLOYEES
SECURE_EMPLOYEES TRIGGER HR.EMPLOYEES
EMP_DETAILS_VIEW VIEW HR.EMPLOYEES
ADD_JOB_HISTORY PROCEDURE HR.JOB_HISTORY
SECURE_EMPLOYEES TRIGGER HR.SECURE_DML
UPDATE_JOB_HISTORY TRIGGER HR.ADD_JOB_HISTORY
17 rows selected.
SQL> --
Related examples in the same category