oracle查询表字段和注释，方便导出excel

SELECT DISTINCT
atc.table_name AS "表名"
,atcom.comments AS "表注释"
,atc.column_id AS "字段序号"
,atc.column_name AS "字段名"
,atc.data_type AS "字段类型"
,CASE WHEN atc.NULLABLE = 'N' THEN '是' ELSE '否' END as "必填"
,atc.data_length AS "字段长度"
,acc.comments 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 = ''
# 数据库表名
and atc.table_name = ''
ORDER BY
atc.table_name,
atc.column_id;