pl/sql(三)循环

1)简单循环  LOOP ... EXIT WHEN ... END LOOP

 

SQL> declare
  2  v_i number(10):=5;
  3  begin
  4  loop
  5  dbms_output.put_line(v_i);
  6  v_i:=v_i+1;
  7  exit when v_i>100;
  8  end loop;
  9  end;

 

2）while循环  WHILE ... LOOP ... END LOOP

 

SQL> declare
  2  v_i number(10):=1;
  3  begin
  4  while v_i<=100 loop
  5  dbms_output.put_line(v_i);
  6  v_i:=v_i+1;
  7  end loop;
  8  end;
  9  /

 

3）for循环  FOR 变量名  IN  REVERSE 1 .. 100 LOOP... END  LOOP;

 

begin
       for i in reverse 1 .. 100 loop
             dbms_output.put_line(i);
       end loop;
end;