oracle 的4个循环例子

create or replace procedure lq_test_xunhuan(username varchar2)
is
userid tmp_lq_test_user_info.user_id%type :=11;
 
begin

--while 循环
/*
  while userid < 21 loop
    insert into tmp_lq_test_user_info values(userid,username) ;
    userid :=userid + 1;
  end loop;
*/

--for 循环
/*
  for userid in 1 .. 4 loop
    --reverse由大到小
    insert into tmp_lq_test_user_info values(userid,username) ;
  end loop;
*/

--loop 循环
/*
loop
  exit when userid > 13 ;
  insert into tmp_lq_test_user_info values(userid,username) ;
  userid :=userid + 1;
end loop ;
*/

--goto 循环
/*
 <<repeat_loop>>
  insert into tmp_lq_test_user_info values(userid,username) ;
  userid :=userid + 1;
if userid < 15 then
  goto repeat_loop;
end if;
*/
end;