oracle循环使用

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

 for counter in value1 .. value2
 loop
   statements;
 end loop;

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