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')
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')
转载于:https://www.cnblogs.com/zshboke-2015/p/5354097.html