Syntax

DESCRIBE { table-Name | view-Name }

Description

Provides a decription of the specified table or view.

Example

   sql> describe majbase_employee;
      
     Name              |   Null?  |   Type
   --------------------| -------- | ----------------------------
   MGB_ID              | NOT NULL | NUMBER(7)
   MGB_ACTIVE          |          | VARCHAR2(40)
   MGB_EMPLOYEE        |          | VARCHAR2(300)
   BASIC_RATE          |          | VARCHAR2(20)
   MGB_CITY            |          | VARCHAR2(20)