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:
while:
for:
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:
- 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;
- 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:
- declare
- i number;
- begin
- i := 1;
- while i<=100 loop
- dbms_output.put_line(i);
- i := i+1;
- end loop;
- end;
- declare
- i number;
- begin
- i := 1;
- while i<=100 loop
- dbms_output.put_line(i);
- i := i+1;
- end loop;
- end;
for:
- declare
- i number;
- begin
- for i in 1..100
- loop
- dbms_output.put_line(i);
- end loop;
- end;