Query all_objects for all packages and package bodies : all_objects « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. all_objects

SQL>
SQL>
SQL> SELECT object_name, object_type
  2  FROM   all_objects
  3  WHERE  owner = 'SYS'
  4  AND    object_type IN ('PACKAGE', 'PACKAGE BODY')
  5  and    rownum < 50
  6  ORDER BY object_name, object_type;

DBMS_ADVISOR              PACKAGE
DBMS_JAVA_TEST            PACKAGE
DBMS_JAVA_TEST            PACKAGE BODY
DBMS_LOB                  PACKAGE
DBMS_LOB                  PACKAGE BODY
DBMS_PICKLER              PACKAGE
DBMS_PICKLER              PACKAGE BODY
DBMS_REGISTRY             PACKAGE
DBMS_REGISTRY             PACKAGE BODY
DBMS_REGISTRY_SERVER      PACKAGE
DBMS_STANDARD             PACKAGE
DIANA                     PACKAGE
DIANA                     PACKAGE BODY

DIUTIL                    PACKAGE
DIUTIL                    PACKAGE BODY
PIDL                      PACKAGE
PIDL                      PACKAGE BODY
PLITBLM                   PACKAGE
STANDARD                  PACKAGE
STANDARD                  PACKAGE BODY
SYS_STUB_FOR_PURITY_ANALY PACKAGE
SIS

UTL_COMPRESS              PACKAGE
UTL_COMPRESS              PACKAGE BODY
UTL_ENCODE                PACKAGE

UTL_ENCODE                PACKAGE BODY
UTL_FILE                  PACKAGE
UTL_FILE                  PACKAGE BODY
UTL_GDK                   PACKAGE
UTL_GDK                   PACKAGE BODY
UTL_HTTP                  PACKAGE
UTL_HTTP                  PACKAGE BODY
UTL_I18N                  PACKAGE
UTL_I18N                  PACKAGE BODY
UTL_INADDR                PACKAGE
UTL_INADDR                PACKAGE BODY
UTL_LMS                   PACKAGE
UTL_LMS                   PACKAGE BODY

UTL_RAW                   PACKAGE
UTL_RAW                   PACKAGE BODY
UTL_SMTP                  PACKAGE
UTL_SMTP                  PACKAGE BODY
UTL_SYS_COMPRESS          PACKAGE
UTL_SYS_COMPRESS          PACKAGE BODY
UTL_TCP                   PACKAGE
UTL_TCP                   PACKAGE BODY
UTL_URL                   PACKAGE
UTL_URL                   PACKAGE BODY
XML_SCHEMA_NAME_PRESENT   PACKAGE
XML_SCHEMA_NAME_PRESENT   PACKAGE BODY

49 rows selected.

SQL>