pl/sql存储过程中游标嵌套的实现方法

-- Created on 2012/3/14 by FREE
declare
  -- Local variables here
  Cursor tbl_cur is select table_name from user_tables;
  --col_cur Cursor;
  i integer;
  tbl_name varchar2(50);
  col_name varchar2(50);
begin
  -- Test statements here
  for tbl_name in tbl_cur LOOP
      for col_cur in (select COLUMN_NAME from all_tab_columns where table_name=tbl_name.table_name) LOOP
          dbms_output.put_line('alter table '||tbl_name.table_name||' rename column "'||col_cur.column_name||'" to '||col_cur.column_name);
      end LOOP;
  end LOOP;
end; 

原文地址