SQL>
SQL> select object_type, object_name
2 from user_objects
3 where object_type = 'PROCEDURE'
4 or object_type = 'FUNCTION';
OBJECT_TYPE OBJECT_NAME
------------------- --------------------------------------------------------------------------------------------------------------------------------
PROCEDURE P_ADD_ITEMS
PROCEDURE ADDTUPLE3
PROCEDURE P_ADD_ORDERS
PROCEDURE P_ADD_PROD
PROCEDURE UPDATE_PRODUCT_PRICE
FUNCTION CIRCLE_AREA
FUNCTION AVERAGE_PRODUCT_PRICE
PROCEDURE NCLOB_EXAMPLE
PROCEDURE ADDTUPLE1
PROCEDURE ADDTUPLE2
FUNCTION MONTH_GENERATOR_PIPED
FUNCTION MONTH_GENERATOR
FUNCTION ORD_GENERATOR_PIPED
FUNCTION ORD_GENERATOR
PROCEDURE PRINT_PRODUCTS
FUNCTION GETPRODUCTTAXIN
FUNCTION F_CORP_PWD_VFY
PROCEDURE ADDSTUDENT
PROCEDURE PROMOTION_REVIEW_2
PROCEDURE PROMOTION_REVIEW_1
PROCEDURE PROMOTION_REVIEW_4
PROCEDURE SUBMULTISET_EXAMPLE
PROCEDURE CUSTOMERS_ASSOCIATIVE_ARRAY
PROCEDURE MULTISET_EXAMPLE
PROCEDURE CARDINALITY_EXAMPLE
PROCEDURE MEMBER_OF_EXAMPLE
PROCEDURE EQUAL_EXAMPLE
PROCEDURE IN_EXAMPLE
PROCEDURE SET_EXAMPLE
PROCEDURE IS_A_SET_EXAMPLE
PROCEDURE IS_EMPTY_EXAMPLE
PROCEDURE ERASE_EXAMPLE
PROCEDURE INITIALIZE_BLOB
PROCEDURE INITIALIZE_CLOB
PROCEDURE READ_BLOB_EXAMPLE
PROCEDURE READ_CLOB_EXAMPLE
PROCEDURE WRITE_EXAMPLE
PROCEDURE APPEND_EXAMPLE
PROCEDURE COMPARE_EXAMPLE
PROCEDURE COPY_EXAMPLE
PROCEDURE TEMPORARY_LOB_EXAMPLE
PROCEDURE MY_RAISE
PROCEDURE DW_STYLE
PROCEDURE OLTP_STYLE
FUNCTION GET_ROW_CNT
PROCEDURE PARALLEL_PROCEDURE
FUNCTION F
PROCEDURE NROWS_AT_A_TIME
PROCEDURE SAL_CHECK
PROCEDURE P2
FUNCTION GET_VALUE_STATIC
FUNCTION GET_VALUE_DYN
PROCEDURE ROW_AT_A_TIME
PROCEDURE ROW_FETCH_ROW_SELECT
PROCEDURE ARRAY_FETCH_HEAP_INSERT
PROCEDURE EXPLICIT
PROCEDURE IMPLICIT
PROCEDURE P_ADD_EMPS
PROCEDURE GEN_CUSTOMER
PROCEDURE INSERT_BLOB_PROC
FUNCTION CCN_DECRYPT
PROCEDURE SEARCHED_CASE
PROCEDURE PROC1
PROCEDURE PROC2
PROCEDURE AUTONOMOUS_INSERT
PROCEDURE NONAUTONOMOUS_INSERT
FUNCTION EXT
FUNCTION EMP_COUNT
PROCEDURE LITERALS
PROCEDURE BINDING
PROCEDURE UPDATE_EMP
PROCEDURE EASY_AS_THAT
FUNCTION BINARY_AND
FUNCTION PIPE_DATE
PROCEDURE P0
PROCEDURE REPORT_SAL_ADJUSTMENT
PROCEDURE REPORT_SAL_ADJUSTMENT2
PROCEDURE REPORT_SAL_ADJUSTMENT3
PROCEDURE REPORT_SAL_ADJUSTMENT4
PROCEDURE XXX
PROCEDURE P4
PROCEDURE P3
PROCEDURE SHOW_SAL
PROCEDURE PRC_0002
PROCEDURE PRC_0001
PROCEDURE PRC_0003
PROCEDURE PRC_0004
PROCEDURE PRC_0005
PROCEDURE PRC_0006
PROCEDURE PRC_0007
PROCEDURE PRC_0008
PROCEDURE PRC_0009
PROCEDURE PRC_0010
PROCEDURE PRC_0011
PROCEDURE PRC_0012
PROCEDURE PRC_0013
PROCEDURE PRC_0014
304 rows selected.
SQL>
SQL>