Query user_dependencies for cross references : user_dependencies « System Tables Views « Oracle PL / SQL






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

1.Check dependencies for procedure
2.Check package reference
3.Check user dependencies for a given table
4.Who referenced current user's objects