oracle查数据表结构与注释

SELECT t.table_name as 表名,
       t.colUMN_NAME as 字段名称,
       t.DATA_TYPE || '(' || t.DATA_LENGTH || ')' as 字段类型,
       t1.COMMENTS as 字段说明
  FROM User_Tab_Cols t, User_Col_Comments t1
WHERE t.table_name = t1.table_name
    AND t.column_name = t1.column_name
    AND T.table_name = 'ZZJLOG'