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

1.情景展示

　　如何将表结构导出到excel中（不是建表的SQL语句），如何实现？

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.TABLE_NAME)
   AND T1.TABLE_NAME = 'ACCESS_APPUSER'--这里改成你的表名
 ORDER BY T1.TABLE_NAME, T1.COLUMN_ID;