查询字段和类型

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

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