SELECT
A.COLUMN_NAME AS "字段名",
A.DATA_TYPE AS "字段类型",
A.CHAR_LENGTH AS "字段长度",
A.NULLABLE AS "能否为空",
B.comments AS "备注"
FROM
all_tab_columns A,
DBA_COL_COMMENTS B
WHERE
A.owner = B.owner
AND A.table_name = B.table_name
AND A.COLUMN_NAME = B.COLUMN_NAME
AND A.owner = 'ADMIN'
AND a.TABLE_NAME = 'CK_FLOW_PERSON' ;
如下图,然后导出即可