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