查询表的列信息

select upper(column_name) as column_name, data_type
from all_tab_columns
where table_name = 'APPR_EXCHANGE_INST'