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‘)
原文：http://www.cnblogs.com/zshboke-2015/p/5354097.html