Wednesday, September 7, 2011

Select from table procedure/package details

I want to search for a particular procedure in the list of packages available in the system. How can it be achieved through SQL script?

SQL> SELECT object_name,procedure_name FROM user_procedures WHERE object_type='PACKAGE' AND procedure_name='procedurename'

No comments:

Post a Comment