Oracle PL/SQL/System Tables Views/tab

Selecting from the TAB view.

   <source lang="sql">
   

SQL> SQL> select * from tab;

TNAME TABTYPE CLUSTERID

---

------- ----------

MYSTATS TABLE WORKING_CUSTOMERS TABLE EMP_HQ VIEW CUST_WITH_VARRAY_TEMP_TABLE TABLE P1 TABLE V VIEW IT TABLE CUST_NO_KEY_TABLE TABLE AVG_SAL VIEW DEMO TABLE P TABLE EMPDEPT_V VIEW CUSTLOG TABLE IX TABLE EMP_DELTAS TABLE PARMS TABLE PASSWORD_AUDIT TABLE DEPT_SAL VIEW DEPT$AUDIT TABLE ALL_ORACLE_ERRORS VIEW INVENTORY_TBL TABLE INVENTORY_VIE VIEW TMP TABLE TOP_EMP VIEW

                         Page:   2

TNAME TABTYPE CLUSTERID

---

------- ----------

EMP_BONUS VIEW SHARED VIEW HD_CLUSTER CLUSTER EMPLOYEETEMPTABLE TABLE SYSTEM_STATS TABLE TEMP_TABLE TABLE MYTABLE1 TABLE C1 TABLE PHONE_LIST VIEW WORKING_EMPLOYEES TABLE 34 rows selected.

 </source>