Query user_objects table : USER_OBJECTS « System Tables Views « Oracle PL / SQL
- Oracle PL / SQL
- System Tables Views
- USER_OBJECTS
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> --
Related examples in the same category