Online Tutorials & Training Materials | STechies.com
Register Login

Dependent Tables of Certain Procedures

|| || 1

Dependent Tables of Certain Procedures
Stechies

Query to know what are all the tables that has been used inside the procedure?

 


Comments

  • Sonia Barwar
    30 Apr 2014 11:05 am

    Hello, 

    You can use the following to see on what objects your procedure depends: 

    SELECT REFERENCED_TYPE, REFERENCED_OWNER, REFERENCED_NAME 
    FROM USER_DEPENDENCIES 
    WHERE TYPE = 'PROCEDURE' 
    AND NAME = '&your_procedure_name' 

    If you want to see tables only, then you can add the condition 

    ... AND REFERENCED_TYPE = 'TABLE' 

    However, please be aware that this statement *WILL NOT* return tables that 
    have been accessed inside the procedure using dynamic SQL statement. 

Related Articles

0.0134 seconds.