Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>