Query user_objects table for all procedure : USER_OBJECTS « System Tables Views « Oracle PL / SQL






Query user_objects table for all procedure

    
SQL>
SQL>
SQL>  select object_name, status
  2      from user_objects
  3     where object_type = 'PROCEDURE' and rownum < 100;

OBJECT_NAME                                                                                                              STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
PSTUBT                                                                                                                   VALID
PSTUB                                                                                                                    VALID
SUBPTXT2                                                                                                                 VALID
SUBPTXT                                                                                                                  VALID
ODCIINDEXINFOFLAGSDUMP                                                                                                   VALID
ODCIINDEXINFODUMP                                                                                                        VALID
ODCIPREDINFODUMP                                                                                                         VALID
ODCIQUERYINFODUMP                                                                                                        VALID
ODCICOLINFODUMP                                                                                                          VALID
ODCISTATSOPTIONSDUMP                                                                                                     VALID
ODCIENVDUMP                                                                                                              VALID

OBJECT_NAME                                                                                                              STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
ODCIINDEXALTEROPTIONDUMP                                                                                                 VALID
ODCIINDEXCALLPROPERTYDUMP                                                                                                VALID
ODCITABFUNCINFODUMP                                                                                                      VALID
LOGMNR_KRVRDLUID3                                                                                                        VALID
LOGMNR_KRVRDREPDICT3                                                                                                     VALID
DBMS_LOGMNR_FFVTOLOGMNRT                                                                                                 VALID
LOGMNR_KRVRDA_TEST_APPLY                                                                                                 VALID
DBMS_LOGMNR_OCTOLOGMNRT                                                                                                  VALID
LOGMNR_GTLO3                                                                                                             VALID
AW_DROP_PROC                                                                                                             VALID
LOAD_UNDO_STAT                                                                                                           VALID

OBJECT_NAME                                                                                                              STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
RESET_UNDO_STAT                                                                                                          VALID
DBMS_FEATURE_PARTITION_USER                                                                                              VALID
DBMS_FEATURE_PARTITION_SYSTEM                                                                                            VALID
DBMS_FEATURE_PLSQL_NATIVE                                                                                                VALID
DBMS_FEATURE_RAC                                                                                                         VALID
DBMS_FEATURE_TEST_PROC_1                                                                                                 VALID
DBMS_FEATURE_TEST_PROC_2                                                                                                 VALID
DBMS_FEATURE_TEST_PROC_3                                                                                                 VALID
DBMS_FEATURE_TEST_PROC_4                                                                                                 VALID
DBMS_FEATURE_TEST_PROC_5                                                                                                 VALID
DBMS_FEATURE_REGISTER_ALLFEAT                                                                                            VALID

OBJECT_NAME                                                                                                              STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
DBMS_FEATURE_REGISTER_ALLHWM                                                                                             VALID
VALIDATE_CONTEXT                                                                                                         VALID
SET_TABLESPACE                                                                                                           VALID
EMP_LOOKUP                                                                                                               INVALID
MY_PROC                                                                                                                  VALID
SHOW_EMP                                                                                                                 INVALID
SWAP                                                                                                                     VALID
LOG_MESSAGE                                                                                                              INVALID
INSERT_INTO_T                                                                                                            INVALID
FOO                                                                                                                      INVALID
INSERT_NUMBERS                                                                                                           INVALID

OBJECT_NAME                                                                                                              STATUS
-------------------------------------------------------------------------------------------------------------------------------- -------
OUT_PARMS                                                                                                                VALID
THREE_PARMS                                                                                                              VALID
DEFAULT_VALUES                                                                                                           VALID
THREE_PARAMS                                                                                                             VALID
SHOW_OBJECTS                                                                                                             VALID
SET_JETSON_CONTEXT                                                                                                       VALID

50 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.list all stored procedures: 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY'
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: