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;
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;