Export the table decribe from oracle data dictionary

select b.TABLE_NAME as tablename,
       --c.comments as "表说明",  
       --b.COLUMN_ID as "字段序号",  
       b.COLUMN_NAME as Name,
       b.DATA_TYPE || '(' || decode(b.DATA_TYPE,
                                    'NUMBER',
                                    b.DATA_PRECISION || ',' || b.DATA_SCALE,
                                    b.DATA_LENGTH) || ')' as type,
       b.NULLABLE,
       b.DATA_DEFAULT ,
       a.comments
  from all_col_comments a, all_tab_columns b, all_tab_comments c
 where a.owner = b.owner
   and a.table_name = b.TABLE_NAME
   and a.column_name = b.COLUMN_NAME
   and c.table_name = a.table_name
   and c.owner = a.owner
   and a.TABLE_NAME in ('T_ACTION','T_ANSWER')
 order by a.table_name, b.column_id;