Query dba_dependencies by owner and referenced_name : dba_dependencies « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. dba_dependencies

Query dba_dependencies by owner and referenced_name

 
SQL>
SQL>
SQL> select owner || '.' || name name, type, dependency_type
  2  from dba_dependencies
  3  where referenced_owner = 'HR' and referenced_name = 'EMPLOYEES'
  4  /
NAME                           TYPE              DEPE
------------------------------ ----------------- ----
HR.EMP_DETAILS_VIEW            VIEW              HARD
HR.SECURE_EMPLOYEES            TRIGGER           HARD
HR.UPDATE_JOB_HISTORY          TRIGGER           HARD

3 rows selected.

SQL>
SQL> --

 

Related examples in the same category