Query dba_dependencies : dba_dependencies « System Tables Views « Oracle PL / SQL






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

1.Query dba_dependencies by owner and referenced_name