declare num number := 1;
begin
while num < 50 loop
insert into testguo id values (100 + num);
commit;
num := num +1;
end loop;
end;
select * from testguo where rownum >=10
declare num number := 1;
begin
while num < 50 loop
insert into testguo id values (100 + num);
commit;
num := num +1;
end loop;
end;
select * from testguo where rownum >=10