COL TIPO             FORMAT A15
COL NOTNULL	     FORMAT A7
COL COLUNA           FORMAT A30
SET DEFINE ON VERIFY OFF
SELECT column_name "Coluna", 
       decode( nullable, 'N', 'Sim' ) "NotNull", 
       data_type || 
       decode( data_type, 'DATE', '',
                          'NUMBER', decode( data_precision, null, '', '('||data_precision||','||data_scale||')'),
			  '(' || data_length || ')' ) "Tipo"
FROM user_tab_columns
WHERE table_name = upper( '&1' )
ORDER BY 1 --COLUMN_ID
/
SET DEFINE OFF VERIFY ON