Select column_name,
Case
When data_type = ‘NUMBER‘ Then
data_type || ‘(‘ || nvl(to_char(data_precision), ‘*‘) || ‘,‘ || nvl(to_char(data_scale),0) || ‘)‘
When data_type In (‘VARCHAR2‘, ‘CHAR‘) Then
data_type || ‘(‘ || to_char(CHAR_LENGTH) || ‘)‘
Else
DATA_TYPE
End As DATA_TYPE,
decode(NULLABLE, ‘Y‘, ‘N‘, ‘N‘, ‘Y‘) As Mandatory,
data_type,
char_length,data_precision,data_scale
From user_tab_columns c
Where table_name = ‘CIS_1WMP_DI_ROLLUP_AUDIT‘
Order By c.COLUMN_ID;
原文：http://2661897.blog.51cto.com/2651897/1924692