-- loop 输入用户名,循环添加10个用户
create or replace procedure sp_pro6(spName varchar2) is
v_num number := 1;
begin
loop
insert into user1 values(v_num,spName);
exit when v_num=10;
--自增
v_num:=v_num+1;
end loop;
end;
-- while 输入用户名,循环添加10个用户
-- while循环和loop的区别是loop不管条件先执行一次,while要先判断条件
create or replace procedure sp_pro7(spName varchar2) is
v_num number :=11;
begin
while v_num<=20 loop
-- 执行
insert into user1 values(v_num,spName);
v_num:=v_num+1;
end loop;
end;
-- for循环
create or replace procedure sp_pro8(spName varchar2) is
begin
for i in 21..30
loop
insert into user1 values(i,spName);
end loop;
end;
create or replace procedure sp_pro6(spName varchar2) is
v_num number := 1;
begin
loop
insert into user1 values(v_num,spName);
exit when v_num=10;
--自增
v_num:=v_num+1;
end loop;
end;
-- while 输入用户名,循环添加10个用户
-- while循环和loop的区别是loop不管条件先执行一次,while要先判断条件
create or replace procedure sp_pro7(spName varchar2) is
v_num number :=11;
begin
while v_num<=20 loop
-- 执行
insert into user1 values(v_num,spName);
v_num:=v_num+1;
end loop;
end;
-- for循环
create or replace procedure sp_pro8(spName varchar2) is
begin
for i in 21..30
loop
insert into user1 values(i,spName);
end loop;
end;