Oracle数据表字段小写转大写

 1 begin
 2     for c in ( select column_name cn from all_tab_columns where table_name = '表名' )
 3     loop
 4 begin
 5     execute immediate 'alter table 表名 rename column "' || c.cn || '" to ' || c.cn;
 6 exception 
 7     when others then
 8     dbms_output.put_line ( '表名' || '.' || c.cn || '已经存在' );
 9 
10 end;
11 
12 end loop;
13 end;