Table and view from obj : obj « System Tables Views « Oracle PL / SQL






Table and view from obj

    
SQL>
SQL>
SQL> select object_name, object_type
  2  from   obj
  3  where  object_type in ('TABLE','VIEW')
  4  order  by object_type, object_name;

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
CUSTLOG
TABLE

CUST_NO_KEY_TABLE
TABLE

CUST_WITH_VARRAY_TEMP_TABLE
TABLE

DEMO
TABLE

DEPT$AUDIT
TABLE

E
TABLE

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------

EMP_DELTAS
TABLE

EMPLOYEETEMPTABLE
TABLE

EMPTEMPTABLE
TABLE

INVENTORY_TBL
TABLE

IT
TABLE

IX

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
TABLE

MYSTATS
TABLE

MYTABLE1
TABLE

P
TABLE

PARMS
TABLE

PASSWORD_AUDIT
TABLE


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
P1
TABLE

SYSTEM_STATS
TABLE

TEMP_TABLE
TABLE

TMP
TABLE

WORKING_CUSTOMERS
TABLE

WORKING_EMPLOYEES
TABLE

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------

WORKING_EMPS
TABLE

ALL_ORACLE_ERRORS
VIEW

AVG_SAL
VIEW

DEPT_SAL
VIEW

EMP_BONUS
VIEW

EMPDEPT_V

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
VIEW

EMP_HQ
VIEW

INVENTORY_VIE
VIEW

PHONE_LIST
VIEW

SHARED
VIEW

TOP_EMP
VIEW


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
V
VIEW


35 rows selected.

SQL>
SQL>

   
    
    
    
  








Related examples in the same category