Oracle PL / SQL View All Tables

SQL*Plus: Release 11.2.0.2.0 Production on Tue Jul 30 15:26:44 2013

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect
Enter user-name: sakib
Enter password:
Connected.
SQL> SELECT * FROM TAB;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
APEX$_ACL                      TABLE
APEX$_WS_FILES                 TABLE
APEX$_WS_HISTORY               TABLE
APEX$_WS_LINKS                 TABLE
APEX$_WS_NOTES                 TABLE
APEX$_WS_ROWS                  TABLE
APEX$_WS_TAGS                  TABLE
APEX$_WS_WEBPG_SECTIONS        TABLE
APEX$_WS_WEBPG_SECTION_HISTORY TABLE
BIN$GjcOCe4nTyqOjoQ/XP3mQQ==$0 TABLE
BIN$aQemt3i5QueBOU2cSMlBmg==$0 TABLE

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
DEMO_CUSTOMERS                 TABLE
DEMO_ORDERS                    TABLE
DEMO_ORDER_ITEMS               TABLE
DEMO_PRODUCT_INFO              TABLE
DEMO_STATES                    TABLE
DEMO_USERS                     TABLE
DEPT                           TABLE
EMP                            TABLE
EMPLOYEES                      TABLE
HTMLDB_PLAN_TABLE              TABLE

21 rows selected.

SQL>