Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Check user dependencies for a given table

SQL> select name, type,   2   referenced_name, referenced_type   3   from user_Dependencies   4   where name = 'EMP_MAINT'   5  / no rows selected SQL>