Oracle Pl / SQL View Table Structure

SQL*Plus: Release 11.2.0.2.0 Production on Tue Jul 30 16:36:06 2013

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

SQL> CONNECT
Enter user-name: sakib
Enter password:
Connected.
SQL> DESC EMPLOYEES;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 EMP_ID                                             NUMBER(5)
 LASTNAME                                           VARCHAR2(20)
 FIRSTNAME                                          VARCHAR2(20)
 ADDRESS                                            VARCHAR2(200)
 CITY                                               VARCHAR2(15)

SQL> DESCRIBE EMPLOYEES;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 EMP_ID                                             NUMBER(5)
 LASTNAME                                           VARCHAR2(20)
 FIRSTNAME                                          VARCHAR2(20)
 ADDRESS                                            VARCHAR2(200)
 CITY                                               VARCHAR2(15)

SQL>

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>

Oracle 11 EX SQL*Plus User Login

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>