SUKER@primary>select * from a;
ID NAME
---------- --------------------------
1 aaa
SUKER@primary>truncate table sqlsave;
表被截断。
执行循环，把a中的内容存入表sqlsave。
declare
ss varchar2(1000);
type c1 is ref cursor;
a_cursor c1;
begin
open a_cursor for
select name from a;
loop
fetch a_cursor into ss;
insert into sqlsave values (ss);
exit when a_cursor%notfound;
end loop;
close a_cursor;
end;
/
查看导入的结果，为什么会多出一行呢？
SUKER@primary>select * from sqlsave;
SQL_TEXT
---------------------------------------
aaa
aaa
是哪里做错？请帮忙指点，多谢！
begin
open a_cursor for
select name from a;
fetch a_cursor into ss;
while a_cursor%found
loop
insert into sqlsave values (ss);
fetch a_cursor into ss;
end loop;
close a_cursor;
end;
/
