Query object_type, object_name from user_objects : USER_OBJECTS « System Tables Views « Oracle PL / SQL






Query object_type, object_name from user_objects

    
SQL>
SQL>
SQL> describe user_objects
 Name                                                                                                      Null?    Type
 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
 OBJECT_NAME                                                                                                        VARCHAR2(128)
 SUBOBJECT_NAME                                                                                                     VARCHAR2(30)
 OBJECT_ID                                                                                                          NUMBER
 DATA_OBJECT_ID                                                                                                     NUMBER
 OBJECT_TYPE                                                                                                        VARCHAR2(19)
 CREATED                                                                                                            DATE
 LAST_DDL_TIME                                                                                                      DATE
 TIMESTAMP                                                                                                          VARCHAR2(19)
 STATUS                                                                                                             VARCHAR2(7)
 TEMPORARY                                                                                                          VARCHAR2(1)
 GENERATED                                                                                                          VARCHAR2(1)
 SECONDARY                                                                                                          VARCHAR2(1)

SQL>
SQL> select object_type, object_name
  2  from user_objects
  3  where rownum < 50
  4  order by object_type, object_name;

OBJECT_TYPE         OBJECT_NAME
------------------- --------------------------------------------------------------------------------------------------------------------------------
CLUSTER             C_COBJ#
CLUSTER             C_FILE#_BLOCK#
CLUSTER             C_OBJ#
CLUSTER             C_TS#
CLUSTER             C_USER#
INDEX               I_CCOL1
INDEX               I_CDEF1
INDEX               I_CDEF2
INDEX               I_CDEF4
INDEX               I_COBJ#
INDEX               I_COL2

OBJECT_TYPE         OBJECT_NAME
------------------- --------------------------------------------------------------------------------------------------------------------------------
INDEX               I_COL3
INDEX               I_CON1
INDEX               I_CON2
INDEX               I_FILE#_BLOCK#
INDEX               I_FILE1
INDEX               I_FILE2
INDEX               I_IND1
INDEX               I_OBJ#
INDEX               I_OBJ1
INDEX               I_OBJ2
INDEX               I_OBJ3

OBJECT_TYPE         OBJECT_NAME
------------------- --------------------------------------------------------------------------------------------------------------------------------
INDEX               I_PROXY_DATA$
INDEX               I_PROXY_ROLE_DATA$_1
INDEX               I_TAB1
INDEX               I_TS#
INDEX               I_TS1
INDEX               I_UNDO1
INDEX               I_UNDO2
INDEX               I_USER1
TABLE               BOOTSTRAP$
TABLE               CCOL$
TABLE               CDEF$

OBJECT_TYPE         OBJECT_NAME
------------------- --------------------------------------------------------------------------------------------------------------------------------
TABLE               CLU$
TABLE               COL$
TABLE               CON$
TABLE               FET$
TABLE               FILE$
TABLE               ICOL$
TABLE               IND$
TABLE               OBJ$
TABLE               PROXY_DATA$
TABLE               PROXY_ROLE_DATA$
TABLE               SEG$

OBJECT_TYPE         OBJECT_NAME
------------------- --------------------------------------------------------------------------------------------------------------------------------
TABLE               TAB$
TABLE               TS$
TABLE               UET$
TABLE               UNDO$
TABLE               USER$

49 rows selected.

SQL>
SQL> column object_name format a30;
SQL>
SQL>

   
    
    
  








Related examples in the same category

1.Query user_objects table
2.Query USER_OBJECTS table by object name
3.Query user_objects table for all procedure
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: