plsql循环案例

PL/SQL的三种形式的循环：
1.LOOP（无条件循环）：
loop
statements;
end loop;
2.WHILE（有条件循环）：
while condition loop
statements;
end loop;
3.FOR（固定次数循环）：
for counter in value1 .. value2
loop
statements;
end loop;

实例：分别用三种循环输出1-100

loop:
view plaincopy to clipboardprint?

declare i number;
begin
i := 1;
loop
if i > 100 then
goto quit;
end if;
dbms_output.put_line(i);
i := i + 1;
end loop;
<<quit>>
null;
end;

 

while:
view plaincopy to clipboardprint?

declare
i number;
begin
i := 1;
while i<=100 loop
dbms_output.put_line(i);
i := i+1;
end loop;
end;

 

for:
view plaincopy to clipboardprint?

declare
i number;
begin
for i in 1..100
loop
dbms_output.put_line(i);
end loop;
end;