Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query user_dependencies for cross references

SQL> SQL> SQL> create table t ( x int ); Table created. SQL> SQL> create or replace view v as select * from t; View created. SQL> SQL> create or replace procedure p   2  as   3  begin   4          for x in ( select * from t )   5          loop   6                  null;   7          end loop;   8  end;   9  / SQL> SQL> create or replace function f return number   2  as   3          countValue number;   4  begin   5          select count(*) into countValue from t;   6          return countValue;   7  end;   8  / Function created. SQL> SQL> select name, type, referenced_name, referenced_type   2    from user_dependencies   3   where referenced_owner = user and rownum < 20   4   order by name   5  / NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- COMPILEERROR                   PROCEDURE DUAL NON-EXISTENT COMPILE_ERROR                  PROCEDURE DUAL NON-EXISTENT NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- DEFINER_RIGHTS                 PACKAGE BODY DUAL NON-EXISTENT LOOPING_EXAMPLE                PROCEDURE DBMS_OUTPUT NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- NON-EXISTENT MONTH_GENERATOR                FUNCTION SQLMONTH_TABLETYPE TYPE MONTH_GENERATOR_PIPED          FUNCTION NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- SQLMONTH_TABLETYPE TYPE ORD_GENERATOR                  FUNCTION ORD_TYPE TYPE NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- ORD_GENERATOR                  FUNCTION ORD_TABLE TYPE ORD_GENERATOR_PIPED            FUNCTION ORD_TABLE TYPE NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- ORD_GENERATOR_PIPED            FUNCTION ORD_TYPE TYPE ORD_TABLE                      TYPE ORD_TYPE NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- TYPE PRODUCT_PACKAGE                PACKAGE BODY PRODUCT_PACKAGE PACKAGE P_ADD_ORDERS                   PROCEDURE NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- DUAL NON-EXISTENT P_ADD_ORDERS                   PROCEDURE ORDER_SEQ NON-EXISTENT NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- P_ADD_ORDERS                   PROCEDURE P_ADD_ITEMS PROCEDURE P_ADD_PROD                     PROCEDURE PRODUCT_SEQ NON-EXISTENT NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- READCLOB                       PROCEDURE DBMS_OUTPUT NON-EXISTENT TEMPERATURE_CONVERSION         PROCEDURE DBMS_OUTPUT NAME                           TYPE ------------------------------ ----------------- REFERENCED_NAME ---------------------------------------------------------------- REFERENCED_TYPE ----------------- NON-EXISTENT USE_G2                         FUNCTION DUAL NON-EXISTENT 19 rows selected. SQL> SQL> drop table t; Table dropped.