Oracle 数据库导出表结构（包含字段名、字段长度、类型，字段注释、表注释） 可导出Excel

select t1.table_name || chr(13) || t3.comments as "表名称及说明",
       t1.column_id,
       t1.table_name as "表名称",
       t1.column_name as "字段名称",
       t1.data_type || '(' || t1.data_length || ')' as "数据类型",
       --t1.data_length  as "长度",
       t1.nullable     as "是否为空",
       t2.comments     as "字段说明",
       t1.data_default "默认值"

  from cols t1
  left join user_col_comments t2
    on t1.table_name = t2.table_name
   and t1.column_name = t2.column_name
  left join user_tab_comments t3
    on t1.table_name = t3.table_name

 where t1.table_name in （ 'OPT_ITEMSTATISTICS' ）
 order by t1.table_name, t1.column_id;

示例结果：