几个存储过程的例子

declare
   width integer;
   area  integer;
   height integer :=2;
   counter integer:=0;
   begin
      /*
        loop
        counter := counter +1;
        area:=6;
        width := area/height;
        dbms_output.put_line(width);
        exit when counter =5;
        end loop;
        */
        /*
         while counter <6 loop
         counter := counter+1;
         area:=6;
         width := area/height;
         dbms_output.put_line(width);
         end loop;
         */
         for count in 0..6 loop
         counter := counter+1;
         area := 6;
         width := area/height;
         dbms_output.put_line(width);
         end loop;
  end;