list all stored procedures: 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY' : USER_OBJECTS « System Tables Views « Oracle PL / SQL






list all stored procedures: 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY'

    
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>

   
    
    
  








Related examples in the same category

1.Query user_objects table
2.Query USER_OBJECTS table by object name
3.Query object_type, object_name from user_objects
4.Query user_objects table for all procedure
5.Query user_objects in PL/SQL
6.Query a view in user_objects table for a view just created
7.Query user_objects for invalid package body
8.Query user-objects for stored procedure
9.Query user_objects for trigger
10.Query user_objects for invalid view
11.Query all INVALID objects from user_objects table
12.Get code for all procedure, function and package from user_objects
13.Query user_objects table for stored procedure before and after recompile
14.If procedure is valid
15.A procedure with dependencies
16.Check package status
17.Check new created tables in user_objects
18.Finding, Validating, and Describing Packages
19.Get object id for created table
20.Show the procedure is marked invalid **
21.Show the status of a procedure
22.To find out what procedures and functions you have created, use the following SQL query: