Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query user_objects table

SQL> SQL> select object_name, object_id from user_objects; OBJECT_NAME                                                                                                               OBJECT_ID -------------------------------------------------------------------------------------------------------------------------------- ---------- MYTABLE_SESSION                                                                                                               15960 DONTCOUNTSP                                                                                                                   16019 DO_COMMIT                                                                                                                     16000 OBJECT_NAME                                                                                                               OBJECT_ID -------------------------------------------------------------------------------------------------------------------------------- ---------- DONE                                                                                                                          16006 MY_TO_DATE                                                                                                                    16018 EXITFUNC                                                                                                                      16020 FACTORIAL                                                                                                                     16021 EMP_CHANGE_S                                                                                                                  16023 LOG_SHUTDOWN                                                                                                                  16086 ADDRESS                                                                                                                       16114 LOG_STARTUP                                                                                                                   16083 ADDRESS                                                                                                                       16115 EMP_PUBLIC_DATA                                                                                                               16091 EMP_NAME_CHANGE                                                                                                               16095 EMP_DEPT_PROCS                                                                                                                16109 EMP_DEPT_PROCS                                                                                                                16110 DEBUG                                                                                                                         16183 ERASE                                                                                                                         16181 GETEMPBLDGNAME                                                                                                                16178 ASSIGNEMPTOBLDG                                                                                                               16165 DEBUG                                                                                                                         16185 ADD_MON                                                                                                                       16184 RAISE                                                                                                                         16187 ASSERT                                                                                                                        16188 MAKE_MYTABLE                                                                                                                  16215 WRITE_NAME                                                                                                                    16216 HELLO                                                                                                                         16219 EMP_CHG                                                                                                                       16237 EMP_CHANGES                                                                                                                   16238 SYS_C005784                                                                                                                   16241 SYS_LOB0000016238C00034$$                                                                                                     16239 AQ$_EMP_CHANGES_S                                                                                                             16242 SYS_C005787                                                                                                                   16243 AQ$_EMP_CHANGES_V                                                                                                             16246 AQ$_EMP_CHANGES_T                                                                                                             16247 AQ$EMP_CHANGES_S                                                                                                              16245 AQ$_EMP_CHANGES_N                                                                                                             16244 SYS_IOT_TOP_16247                                                                                                             16248 AQ$_EMP_CHANGES_H                                                                                                             16249 EMPLOYEES_LIST                                                                                                                14844 EMPLOYEE_TYPE                                                                                                                 14841 VIEW_T                                                                                                                        14933 STATE_PACKAGE                                                                                                                 14802 SHAPE                                                                                                                         14931 DEPT_EMP_VIEW                                                                                                                 14853 IO_BIFER_DEPT_EMP_VIEW                                                                                                        15100 DEPARTMENT_10                                                                                                                 14945 COMPILE_SCHEMA_TMP_PK                                                                                                         15343 GET_NEXT_OBJECT_TO_COMPILE                                                                                                    15337 COMPILE_SCHEMA                                                                                                                15339 COMPILE_SCHEMA_TMP                                                                                                            15342 PRINT_TABLE                                                                                                                   15344 SHOW_SPACE                                                                                                                    15346 DEBUG_TIMER                                                                                                                   15423 VC2TAB                                                                                                                        15365 P                                                                                                                             15805 PEOPLE                                                                                                                        15427 PEOPLE                                                                                                                        15428 P_ADD_PROD                                                                                                                    15572 P_ADD_EMPS                                                                                                                    15746 P_ADD_ORDERS                                                                                                                  15758 MEASURE_USAGE                                                                                                                 15811 SYS_IOT_TOP_15816                                                                                                             15817 UPPER_ENAME                                                                                                                   15816 SHOW_IOT_SPACE                                                                                                                15830 SYS_IOT_TOP_16249                                                                                                             16250 SYS_IOT_OVER_16251                                                                                                            16252 AQ$_EMP_CHANGES_G                                                                                                             16251 SYS_IOT_TOP_16251                                                                                                             16253 AQ$_EMP_CHANGES_I                                                                                                             16254 SYS_IOT_TOP_16254                                                                                                             16255 AQ$_EMP_CHANGES_E                                                                                                             16260 AQ$_EMP_CHANGES_F                                                                                                             16259 AQ$EMP_CHANGES                                                                                                                16257 EMP_DEPT_CHANGES_R                                                                                                            16262 EMP_DEPT_CHANGES_N                                                                                                            16263 AQ$EMP_CHANGES_R                                                                                                              16264 EMP_DEPT_CHANGES                                                                                                              16261 DEPT_AND_EMP                                                                                                                  16299 FILE_DUMP                                                                                                                     16351 EMP_REG                                                                                                                       16294 EMP_TYPE                                                                                                                      16297 EMP_TAB_TYPE                                                                                                                  16298 EMPS_NT                                                                                                                       16300 SYS_C005826                                                                                                                   16301 SYS_C005827                                                                                                                   16302 SUPER_TYPE                                                                                                                    16436 SESS_EVENT                                                                                                                    16377 NEW_PERSON                                                                                                                    16549 PERSON                                                                                                                        16449 NEW_PERSON                                                                                                                    16550 LOGON_TRIGGER                                                                                                                 16373 VIRTUAL_TABLE_TYPE                                                                                                            16647 ROWTYPE                                                                                                                       16642 ELEMENTTYPE                                                                                                                   16641 RESULTTYPE                                                                                                                    16643 COMPANY_LISTING                                                                                                               16515 PIVOT                                                                                                                         16644 VIRTUAL_TABLE                                                                                                                 16648 T1                                                                                                                            16999 OBJECT_NAME                                                                                                               OBJECT_ID -------------------------------------------------------------------------------------------------------------------------------- ---------- REMOVE_CONSTANTS                                                                                                              16650 SQL_AREA_TMP                                                                                                                  16651 TEMP_EMP                                                                                                                      16944 T2                                                                                                                            17000 104 rows selected. SQL> SQL> drop table t1; Table dropped. SQL> drop table t2; Table dropped. SQL> --