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' ;
如下图,然后导出即可
![](https://img-blog.csdnimg.cn/20200819105852262.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzMwNDU4MjA5,size_16,color_FFFFFF,t_70)