Selecting from the TAB view. : tab « System Tables Views « Oracle PL / SQL






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.

   
    
    
    
  








Related examples in the same category