select t.COLUMN_NAME,
decode(s.DATA_TYPE,
'DATE',
'DATE',
s.DATA_TYPE || '(' || s.DATA_LENGTH || ')'),
t.COMMENTS
from all_col_comments t, all_tab_columns s
where t.Table_Name = '表名大写'
and s.Table_Name = '表名大写'
and t.owner = '用户名'
and s.owner = '用户名'
and t.COLUMN_NAME = s.COLUMN_NAME
order by t.column_name;