主要有以下五种循环:Exit When、Loop、While、For(普通循环)、For(游标循环)
==================================================================
1、Exit When循环
---------------------------------------------------------------------------------------------------------
declare
i number;
begin
i:=0;
LOOP
Exit When(i>5);
Dbms_Output.put_line(i);
i:=i+1;
END LOOP;
end;
==================================================================
2、Loop循环
---------------------------------------------------------------------------------------------------------
declare
i number;
begin
i:=0;
loop
i:=i+1;
dbms_output.put_line(i);
if i>5 then
exit;
end if;
end loop;
end;
==================================================================
3、while循环
---------------------------------------------------------------------------------------------------------
declare
i number;
begin
i := 0;
while i < 5 loop
i := i + 1;
dbms_output.put_line(i);
end loop;
end;
==================================================================
4、for普通循环
---------------------------------------------------------------------------------------------------------
declare
i number;
begin
i := 0;
for i in 1 .. 5 loop
dbms_output.put_line(i);
end loop;
end;
==================================================================
5、for游标循环
---------------------------------------------------------------------------------------------------------
declare
userRow t_test_01%rowtype;
cursor userRows is
select * from t_test_01;
begin
for userRow in userRows loop
dbms_output.put_line(userRow.fid ||'|'||userRow.month||'|' || userRows%rowcount);
end loop;
end;
==================================================================
原文地址:http://www.cnblogs.com/zsdentist/archive/2011/12/04/2276249.html
---------------------------------------------------------------------------------------------------------