follwoing 2 ways to get the Procedure details in oracle Way 1: Select OBJECT_NAME As ProcName, dbms_metadata.GET_DDL('PROCEDURE',u.object_name) As Details From user_objects u Where object_type = 'PROCEDURE'; Way 2: Select OBJECT_NAME As ProcName, dbms_metadata.GET_DDL('PROCEDURE',OBJECT_NAME) As Details From ALL_OBJECTS Where object_type = 'PROCEDURE' and OWNER = 'SYSTEM' Order by Object_Name
No comments:
Post a Comment