plsql循环执行语句

for循环

-- set serveroutput on 
 begin
   for i in 1..3
   loop
        insert into tbl_test(name,age) values('name',2);
   end loop;
   end;

 

 

while循环

 

declare
       vcount number(2):=1;
       vnum number(10):=1;
       begin
            while vcount < 6
            loop
                vnum:=vnum+1;
                vcount:=vcount+1;
            end loop;
       end;

 

 

 

 

 

 declare
        vid number(10):=1;
        vorderno number(10):=1;
 begin
      for i in 1..1000
      loop
         insert into tbl_feifei_test (id, time, orderNo, tile, amount, accountNo, tradeType, user, chail, fetchDAte) values
 (vid, to_date('2008-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss'), vorderno, '', 100, 'feifei', 'A', 'feifei', '10177', sysdate);

 vid:=vid+1;
  vorderno:=vorderno+1;

   end loop;
   end;