Friday, 25 May 2012

Write the SQL query to view all the procedures within a schema. | PL SQL

 SQL query to view all the procedures within a schema is as follows:
Select object_name from USER_OBJECTS where
object_type='PROCEDURE'order by object_name;