Select ROWNUM, T.* From (Select column_name,
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
;
--结束END--
本文标题: 查询Oracle 表字段
本文链接: https://www.lsjlt.com/news/43551.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
2024-05-14
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0