How to list all packages from Oracle database

How to list all packages from Oracle database

To list all packages 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='PACKAGE';

SELECT * FROM ALL_PROCEDURES WHERE OBJECT_TYPE='PACKAGE';

SELECT * FROM DBA_PROCEDURES WHERE OBJECT_TYPE='PACKAGE';

SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE='PACKAGE';