查詢Oracle表結構和注釋資訊

SELECT t1.COMMENTS as 中文名稱,
       t.colUMN_NAME as 字段名稱,
       t.DATA_TYPE as 類型,
       t.data_precision as 長度,
       t.data_scale as 精度,
       t.nullable 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 = 'table';