一:LOOP-EXIT-END循环
cnt:=1;
loop
cnt:=cnt+1;
if cnt>100 then
exit;
end if;
end loop;
二:LOOP-EXIT WHEN-END
cnt:=1;
loop
cnt:=cnt+1;
exit when cnt>100
end loop;
三:WHILE-LOOP-END
cnt:=1;
while cnt<=100 loop
cnt:=cnt+1;
end loop;
四:FOR-IN-LOOP-END
for cnt in 1..3 loop
insert into table values('Still in loop',cnt);
end loop;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8020322/viewspace-207306/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8020322/viewspace-207306/