declare i int;
begin
i:=0;
while i < 1000
loop
select * from table where rownum<1000;
i:=i+1;
commit;
end loop;
end;
declare i int;
begin
i:=0;
while i < 1000
loop
select * from table where rownum<1000;
i:=i+1;
commit;
end loop;
end;