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