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.
Related examples in the same category