Category Archives: HowTo

How to get a list of all functions and procedures in an Oracle database

Get a list of all functions and procedures in an Oracle database

SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE')

Click here to view Oracle documentation – ALL_OBJECTS

You could use the view ALL_PROCEDURES.

SELECT * FROM ALL_PROCEDURES

From the results, the column OBJECT_NAME will show you the name of standalone functions and procedures, and packages names. The column PROCEDURE_NAME will show you the names of functions and procedures inside a package.