plsql导出表结构到excel_plsql 将表结构导出到excel中的两种方式

1.情景展示

2.方式一

新建一个SQL窗口，输入要导出结构的表，选中右键--》描述

右键--》导出--》CSV文件

保存到桌面，并为该文件起个名字。

打开该文件，如下图所示

3.方式二

SELECT T1.TABLE_NAME AS "表名称",

T3.COMMENTS AS "表说明",

T1.COLUMN_NAME AS "字段名称",

T1.DATA_TYPE AS "数据类型",

T1.DATA_LENGTH AS "长度",

T1.NULLABLE AS "是否为空",

T2.COMMENTS AS "字段说明",

T1.DATA_DEFAULT "默认值"

FROM COLS T1

LEFT JOIN USER_COL_COMMENTS T2

ON T1.TABLE_NAME = T2.TABLE_NAME

AND T1.COLUMN_NAME = T2.COLUMN_NAME

LEFT JOIN USER_TAB_COMMENTS T3

ON T1.TABLE_NAME = T3.TABLE_NAME

WHERE NOT EXISTS (SELECT T4.OBJECT_NAME

FROM USER_OBJECTS T4

WHERE T4.OBJECT_TYPE = 'TABLE'

AND T4.TEMPORARY = 'Y'

AND T4.OBJECT_NAME = T1.TAB