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