oracle得到某数据库表结构代码并导出为excel文件

代码如下~~~~~

SELECT DISTINCTatc.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 \"表数据量\"FROMall_tab_columns atcINNER join all_col_comments acc ON atc.table_name = acc.table_name AND atc.owner = acc.owner AND atc.column_name = acc.column_nameINNER 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.ownerWHEREatc.owner = \'SFCPX\'ORDER BYatc.table_name,atc.column_id;