生成数据字典

SELECT A.TABLE_NAME AS "表名",
       A.COLUMN_NAME AS "字段名",
       DECODE(A.CHAR_LENGTH,
              0,
              DECODE(A.DATA_SCALE,
                     NULL,
                     A.DATA_TYPE,
                     A.DATA_TYPE || '(' || A.DATA_PRECISION || ',' ||
                     A.DATA_SCALE || ')'),
              A.DATA_TYPE || '(' || A.CHAR_LENGTH || ')') as "字段类型",
       A.DATA_DEFAULT AS "默认值",
       A.NULLABLE AS "能否为空",
       B.comments AS "备注",b.*
  FROM sys.user_tab_columns A, sys.user_col_comments B
 WHERE A.table_name = B.table_name
   AND A.COLUMN_NAME = B.COLUMN_NAME
   and a.TABLE_NAME = 'dual'