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;