循环+查询前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