oracle导出表字段

-- oracle导出表字段
SELECT
c.owner AS "所属用户",
c.table_name AS "表名称",
c.column_name AS "字段名称",
c.data_type AS "数据类型",
c.data_length AS "长度",
CASE WHEN c.nullable = 'Y' THEN '是' ELSE '否' END AS "是否可为空",
cc.comments AS "字段说明"
FROM
all_tab_columns c
LEFT JOIN
all_col_comments cc
ON
c.owner = cc.owner AND c.table_name = cc.table_name AND c.column_name = cc.column_name
WHERE
-- c.table_name = 'AG_PERSON_FITER_UP'
c.owner = 'AAAAAA'
ORDER BY
c.table_name, c.column_id;