CREATE OR REPLACE procedure LIYANG.xxc_insert_user1(name in varchar2) is
begin
declare
v_num number:=1;
begin
loop
insert into userid values(v_num,name);
exit when v_num=10;
v_num:=v_num+1;
end loop;
end;
end;
/
少了一个BEGIN。。END
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024