Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>