Select ROWNUM, T.*
From (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 AS data_type1,
char_length,
data_precision,
data_scale
From user_tab_columns c
Where table_name = 'CIS_1WMP_ASM_ADDR_UM_RN'
Order By c.COLUMN_ID) T
;
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
