Просмотр исходного текста страницы Oracle PL/SQL Tutorial/System Tables Data Dictionary/all objects

== Query all_objects for all packages and package bodies==



   
  <!-- start source code -->
   
    <source lang="sql">
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></source>
    
   

== Query all_objects table by object_id==



   
  <!-- start source code -->
   
    <source lang="sql">
SQL>
SQL> select owner, object_name
  2  from all_objects
  3  where object_id = 2408;
OWNER                          OBJECT_NAME
------------------------------ ------------------------------
PUBLIC                         DBA_SYS_PRIVS
SQL></source>