/*************************************************** 
 ORACLE 
 Desc[ribe] table
 List columns, datatype and other info 
***************************************************/
 
SELECT column_name, data_type, data_length, nullable, data_default 
FROM   user_tab_columns
WHERE  table_name = 'STUDENT'                       -- must be uppercase
ORDER BY column_id; 


select *                                -- select all columns 
from user_tab_columns
where table_name = 'STUDENT'            
ORDER BY column_id;