查询字段属性 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 -----------------------------------------------------------------------------