Oracle PL/SQL 循環

LOOP循環

declare
 i binary_integer := 1;
begin
 loop
    dbms_output.put_line(i);
    i := i+1;
    exit when (i>=11);
 end loop;
end;
           

While循環

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

For循環

begin
 for k in 1..10 loop
  dbms_output.put_line(k);
 end loop;
end;
/
           

逆序

begin
 for k in reverse 1..10 loop
  dbms_output.put_line(k);
 end loop;
end;