Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Selecting from the TAB view

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.