Sunday, 30 December 2012

Oracle information about package , function , procedure


To find out information about package , function , procedure etc :-

SQL> set long 100000
SQL> select TEXT from  dba_source where name = '<package_name>';
SQL> SELECT REFERENCED_NAME,REFERENCED_OWNER,REFERENCED_TYPE,DEPENDENCY_TYPE FROM DBA_DEPENDENCIES WHERE NAME= '<package_name>';

SQL> SELECT REFERENCED_NAME,REFERENCED_OWNER,REFERENCED_TYPE,DEPENDENCY_TYPE FROM DBA_DEPENDENCIES WHERE NAME= '<package_name>' AND REFERENCED_TYPE IN ('TABLE','SYNONYM');

No comments:

Post a Comment