List all procedures from a schema of Oracle database | PL/SQL Tutorial Oracle for beginners

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';