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.
The most used to show the packages in the database are USER_OBJECTS and USER_PROCEDURES.
Privileges may be required to query certain tables or views.

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