查询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
-----------------------------------------------------------------------------

转载于:https://blog.51cto.com/mjingy/1123451