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;

Oracle 表字段