Oracle table select
ORACLE导出数据库所有表结构为EXCEL文件(只需要把数据库名改为对应的数据库即可，需要单个的话，在Where中加入atc.table_name为单表即可)：
SELECT DISTINCT
atc.table_name AS "表名"
,atcom.comments AS "表注释"
,atc.column_id AS "字段序号"
,atc.column_name AS "字段名"
,atc.data_type AS "字段类型"
,atc.data_scale AS "字段精度"
,atc.data_length AS "字段长度"
,acc.comments AS "字段注释"
,allt.num_rows as "表数据量"
FROM
all_tab_columns atc
INNER join all_col_comments acc ON atc.table_name = acc.table_name AND atc.owner = acc.owner AND atc.column_name = acc.column_name
INNER join all_tab_comments atcom ON atc.table_name = atcom.table_name AND atcom.owner = acc.owner AND atcom.table_type = 'TABLE'
INNER join all_tables allt on atc.table_name = allt.table_name AND atc.owner = allt.owner
WHERE
atc.owner = '数据库名'
ORDER BY
atc.table_name,
atc.column_id;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23757700/viewspace-2896840/ ，如需转载，请注明出处，否则将追究法律责任。
