plsql的三种循环

–循环语句有loop/while/for
–loop
declare
tnum number:=1;
begin

loop
exit when tnum>10;
dbms_output.put_line(tnum);
tnum :=tnum+1;
end loop;
end;

–while
declare
tnum number:=1;
begin
while tnum<=10 loop
dbms_output.put_line(tnum);
tnum :=tnum+1;
end loop;
end;

–for

declare
tnum number:=1;
begin
for tnum in 1…10 loop
dbms_output.put_line(tnum);

end loop;
end;