--pl/sql loop循环
create or replace procedure add_users(name_in in varchar2) is
--定义,:=表示赋值
v_num number:=1;
begin
loop--(类似do....while)
insert into users values(v_num,name_in);
--判断是否要退出循环
exit when v_num = 10;
--自增
v_num:=v_num+1;
end loop;
end add_users;
create or replace procedure add_users(name_in in varchar2) is
--定义,:=表示赋值
v_num number:=1;
begin
loop--(类似do....while)
insert into users values(v_num,name_in);
--判断是否要退出循环
exit when v_num = 10;
--自增
v_num:=v_num+1;
end loop;
end add_users;