pl/sql 循环控制

例子如下：

/*循环结构*/
/*
1,loop..exit..end loop
2,loop...exit..when..end loop
*/
declare
  number1 int := 9;
  number2 int := 20;
  i       int := 0;
begin
  loop
    if number1 = number2 then
      exit;
    else
      i := i + 1;
      number1 :=number1 + 1;
    end if;
  end loop;
  dbms_output.put_line(i);
end;

/*2,loop...exit..when..end loop*/
declare
  number1 int := 9;
  number2 int := 20;
  i       int := 0;
begin
  loop
    i       := i + 1;
    number1 := number1 + 1;
    exit when number1 = number2;
  end loop;
  dbms_output.put_line(i);
end;
/*while..loop..end loop*/
declare
  number1 int := 12;
  number2 int := 20;
  i       int := 0;
begin
  while number1 < number2 loop
    i       := i + 1;
    number1 := number1 + 1;
  end loop;
  dbms_output.put_line(i);
end;
/*for..in..loop..end*/
declare
  number1 int := 12;
  number2 int := 20;
  i       int := 0;
begin
  for j in number1..number2 loop 
      i := i + 1;
  end loop;
  dbms_output.put_line(i);
end;