Oracle: check the structure of a table

Oracle: check the structure of a table named test_table,  just using the follwoing command:

 

describe test_table;

 

the output has 3 columns:

 

the first column displays the column name of table dual;

 

the second column displays whether this column can be null;

 

the third column displays the Data Type of the column. 

 

E.g:

 

Check the structure of dual table:

 

describe dual;

 

The output is:

 

describe dual
Name  Null Type       
----- ---- -----------
DUMMY      VARCHAR2(1)  

 

This indicate that dual table has only one column named DUMMY, it can be null, and the type of column DUMMY is VARCHAR2(1).