Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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> --