oracle 查看表字段属性_查询oracle数据库表字段属性信息

修改需要查询的表名。

----------------------------------------------------------------------------

SELECT  a1.column_name                        AS 字段名称

,CASE

WHEN a1.data_precision IS NULL THEN a1.data_type||'('||a1.data_length||')'

ELSE a1.data_type||'('||a1.data_length||','||a1.data_precision||')'

END                                   AS 字段属性

,CASE

WHEN a2.comments IS NULL THEN '未知'

ELSE a2.comments

END                                   AS 字段描述

FROM    USER_TAB_COLUMNS         a1

LEFT JOIN USER_COL_COMMENTS      a2

ON      a1.table_name = a2.table_name

AND     a1.column_name = a2.column_name

WHERE   a1.table_name = upper(

'so_creditaudit'   -- 填写表名

)

ORDER BY a1.column_id

-----------------------------------------------------------------------------