List all functions from Oracle database

How to list all functions from Oracle database

To list all functions from Oracle database you can query: USER_PROCEDURES, ALL_PROCEDURES, DBA_PROCEDURES, USER_OBJECTS.

Examples

  
SELECT * FROM USER_PROCEDURES ;

SELECT * FROM USER_PROCEDURES WHERE OBJECT_TYPE='FUNCTION';

SELECT * FROM ALL_PROCEDURES WHERE OBJECT_TYPE='FUNCTION';

SELECT * FROM DBA_PROCEDURES WHERE OBJECT_TYPE='FUNCTION';

SELECT * FROM USER_OBJECTS 
WHERE OBJECT_TYPE='FUNCTION' AND ORACLE_MAINTAINED='N';