12PL_SQl过程之三种循环

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


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


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