-- 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;
pl/sql存储过程中游标嵌套的实现方法
最新推荐文章于 2022-09-28 17:07:58 发布