How to list all procedures from a schema of Oracle database
To list all procedures from a schema of Oracle database you can query tables: USER_PROCEDURES, ALL_PROCEDURES, DBA_PROCEDURES, USER_OBJECTS.
Examples
SELECT * FROM USER_PROCEDURES ; SELECT * FROM USER_PROCEDURES WHERE OBJECT_TYPE='PROCEDURE'; SELECT * FROM USER_PROCEDURES WHERE OBJECT_TYPE='PACKAGE' AND PROCEDURE_NAME IS NOT NULL; SELECT * FROM ALL_PROCEDURES WHERE OBJECT_TYPE='PROCEDURE'; SELECT * FROM ALL_PROCEDURES WHERE OBJECT_TYPE='PACKAGE' AND PROCEDURE_NAME IS NOT NULL; SELECT * FROM DBA_PROCEDURES WHERE OBJECT_TYPE='PROCEDURE'; SELECT * FROM DBA_PROCEDURES WHERE OBJECT_TYPE='PACKAGE' AND PROCEDURE_NAME IS NOT NULL; SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE';