DESCRIBE

Description:

Use the DESCRIBE command to display the 

structure of a table.

The command displays The description for tables,

views, types and synonyms contains the following 

information:

• - each column's name.

• - whether or not null values are allowed (NULL or NOT NULL) for each column. 

• - datatype of columns, for example, CHAR, DATE, LONG, LONGRAW, NUMBER, RAW, ROWID, VARCHAR2 (VARCHAR), or XMLType. 

• - precision of columns (and scale, if any, for a numeric column).

Syntax: 

 

DESC[RIBE] tablename

Examples: 

  

DESCRIBE employees

Or

DESC employees