To find out what procedures and functions you have created, use the following SQL query: : USER_OBJECTS « System Tables Views « Oracle PL / SQL






To find out what procedures and functions you have created, use the following SQL query:

    

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>

   
    
    
    
  








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.list all stored procedures: 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY'
6.Query user_objects in PL/SQL
7.Query a view in user_objects table for a view just created
8.Query user_objects for invalid package body
9.Query user-objects for stored procedure
10.Query user_objects for trigger
11.Query user_objects for invalid view
12.Query all INVALID objects from user_objects table
13.Get code for all procedure, function and package from user_objects
14.Query user_objects table for stored procedure before and after recompile
15.If procedure is valid
16.A procedure with dependencies
17.Check package status
18.Check new created tables in user_objects
19.Finding, Validating, and Describing Packages
20.Get object id for created table
21.Show the procedure is marked invalid **
22.Show the status of a procedure