Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query user_dependencies

SQL>  SELECT    name, type   2  FROM      user_dependencies   3  WHERE     referenced_name = UPPER('&object_name')   4  AND       referenced_type = UPPER('&object_type')   5  and       rownum < 2   6  ORDER BY  name;