Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

List all stored procedures

SQL> SQL> select object_name, object_type   2      from user_objects   3     where object_type in ( 'PROCEDURE', 'FUNCTION','PACKAGE', 'PACKAGE BODY' )   4     and rownum < 50; OBJECT_NAME                                                                                                              OBJECT_TYPE -------------------------------------------------------------------------------------------------------------------------------- ------------------- STANDARD                                                                                                                 PACKAGE STANDARD                                                                                                                 PACKAGE BODY DBMS_STANDARD                                                                                                            PACKAGE DBMS_REGISTRY                                                                                                            PACKAGE DBMS_REGISTRY                                                                                                            PACKAGE BODY DBMS_REGISTRY_SERVER                                                                                                     PACKAGE XML_SCHEMA_NAME_PRESENT                                                                                                  PACKAGE XML_SCHEMA_NAME_PRESENT                                                                                                  PACKAGE BODY UTL_RAW                                                                                                                  PACKAGE DBMS_ADVISOR                                                                                                             PACKAGE PLITBLM                                                                                                                  PACKAGE OBJECT_NAME                                                                                                              OBJECT_TYPE -------------------------------------------------------------------------------------------------------------------------------- ------------------- SYS_STUB_FOR_PURITY_ANALYSIS                                                                                             PACKAGE PIDL                                                                                                                     PACKAGE PIDL                                                                                                                     PACKAGE BODY DIANA                                                                                                                    PACKAGE DIANA                                                                                                                    PACKAGE BODY DIUTIL                                                                                                                   PACKAGE DIUTIL                                                                                                                   PACKAGE BODY PSTUBT                                                                                                                   PROCEDURE PSTUB                                                                                                                    PROCEDURE SUBPTXT2                                                                                                                 PROCEDURE SUBPTXT                                                                                                                  PROCEDURE OBJECT_NAME                                                                                                              OBJECT_TYPE -------------------------------------------------------------------------------------------------------------------------------- ------------------- DBMS_PICKLER                                                                                                             PACKAGE DBMS_PICKLER                                                                                                             PACKAGE BODY DBMS_JAVA_TEST                                                                                                           PACKAGE DBMS_JAVA_TEST                                                                                                           PACKAGE BODY UTL_FILE                                                                                                                 PACKAGE UTL_FILE                                                                                                                 PACKAGE BODY UTL_RAW                                                                                                                  PACKAGE BODY UTL_TCP                                                                                                                  PACKAGE UTL_TCP                                                                                                                  PACKAGE BODY UTL_INADDR                                                                                                               PACKAGE UTL_INADDR                                                                                                               PACKAGE BODY OBJECT_NAME                                                                                                              OBJECT_TYPE -------------------------------------------------------------------------------------------------------------------------------- ------------------- UTL_SMTP                                                                                                                 PACKAGE UTL_SMTP                                                                                                                 PACKAGE BODY UTL_HTTP                                                                                                                 PACKAGE UTL_HTTP                                                                                                                 PACKAGE BODY UTL_URL                                                                                                                  PACKAGE UTL_URL                                                                                                                  PACKAGE BODY UTL_ENCODE                                                                                                               PACKAGE UTL_ENCODE                                                                                                               PACKAGE BODY UTL_GDK                                                                                                                  PACKAGE UTL_GDK                                                                                                                  PACKAGE BODY DBMS_LOB                                                                                                                 PACKAGE OBJECT_NAME                                                                                                              OBJECT_TYPE -------------------------------------------------------------------------------------------------------------------------------- ------------------- DBMS_LOB                                                                                                                 PACKAGE BODY UTL_SYS_COMPRESS                                                                                                         PACKAGE UTL_SYS_COMPRESS                                                                                                         PACKAGE BODY UTL_COMPRESS                                                                                                             PACKAGE UTL_COMPRESS                                                                                                             PACKAGE BODY 49 rows selected. SQL>