oracle所有表结构包含注释信息PLSQL导出excle格式

先查出所有表:

SELECT

C.COMMENTS AS "中文表名",

B.TABLE_NAME AS "英文表名",

A.COMMENTS AS "字段说明",

B.COLUMN_NAME AS "英文字段",

B.DATA_TYPE AS "数据类型",

B.NULLABLE AS "是否为空"

FROM ALL_COL_COMMENTS A, ALL_TAB_COLUMNS B, ALL_TAB_COMMENTS C

WHERE A.TABLE_NAME IN (SELECT U.TABLE_NAME FROM USER_ALL_TABLES U)

AND A.OWNER = B.OWNER

AND A.TABLE_NAME = B.TABLE_NAME

AND A.COLUMN_NAME = B.COLUMN_NAME

AND C.TABLE_NAME = A.TABLE_NAME

AND C.OWNER = A.OWNER

ORDER BY A.TABLE_NAME, B.COLUMN_ID;
 

再点一下获取最后一页，选中所有数据，右键，导出，excle格式