MYSQL和ORACL导出表结构为EXCEL

MYSQL导出EXCEL写法

SELECT
    COLUMN_NAME 列名,
    COLUMN_TYPE 数据类型,
    DATA_TYPE 字段类型,
    CHARACTER_MAXIMUM_LENGTH 长度,
    IS_NULLABLE 是否为空,
    COLUMN_DEFAULT 默认值,
    COLUMN_COMMENT 备注
FROM
    INFORMATION_SCHEMA.COLUMNS
where

--'db_qiganju' 数据库名称
table_schema ='db_qiganju'
AND

--'r_db_303127421'表名称
table_name = 'r_db_303127421'

---

oracle导出EXCEL写法

SELECT a.COLUMN_NAME 列名,
       --a.COLUMN_TYPE 数据类型,
       a.DATA_TYPE 数据类型,
       a.DATA_LENGTH 长度,
       a.NULLABLE 是否为空,
       --a.COLUMN_DEFAULT 默认值,
       b.COMMENTS 备注
from ALL_TAB_COLUMNS a,ALL_COL_COMMENTS b
WHERE a.OWNER=b.OWNER AND a.TABLE_NAME=b.TABLE_NAME AND a.COLUMN_NAME=b.COLUMN_NAME
            --'NMGZWBI_USER='用户,'R_DEBT_RISK' = 表名
      AND a.OWNER='NMGZWBI_USER' AND a.TABLE_NAME='R_DEBT_RISK'
ORDER BY a.COLUMN_ID;

原文链接：https://blog.csdn.net/mocangli/article/details/108254047