oracle导出数据库某些表的字段名称，字段类型，字段注释：注意表名字要大写

select  '表A' as COLUMN_NAME,'' as DATA_TYPE ,'' as comments from dual  
union all
select 
      ut.COLUMN_NAME as COLUMN_NAME,
      ut.DATA_TYPE as DATA_TYPE,
      uc.comments as comments
from user_tab_columns  ut
inner JOIN user_col_comments uc
on ut.TABLE_NAME  = uc.table_name and ut.COLUMN_NAME = uc.column_name
where ut.TABLE_NAME='表A' 
union all

select '表B' as COLUMN_NAME,'' as DATA_TYPE ,'' as comments from dual  
union all
select 
      ut.COLUMN_NAME as COLUMN_NAME,
      ut.DATA_TYPE as DATA_TYPE,
      uc.comments as comments
from user_tab_columns  ut
inner JOIN user_col_comments uc
on ut.TABLE_NAME  = uc.table_name and ut.COLUMN_NAME = uc.column_name
where ut.TABLE_NAME='表B' 

注意事项：

表A和表B的名字必须大写，如果为小写，则查不出来数据