我不大懂存储过程的,想批量插入一堆数据到某个表里,主键pid是自增长的,sequence是s_personinfo ,表是tbpersoninfo表Insert into TBPERSONINFO (IPERSONINFOID,VCPERSONCARD,VCPASSWORD,VCPERSONNAME,VCPERSIONSEX) values (s_personinfo.nextval,'33000021','123456','小明','男',); //这个语句想循环500遍.
解决方案 »
- csdn是用什么技术生成的静态页
- 我应该下载哪个WebLogic?
- jsp中导出的excel文件为何没表格且背景色为空白色,大家看一下(特邀小钧、菜无心)
- 初学者,问几个EJB小问题
- 问:JSP既然是在servlet上发展起来的且综合了servlet的全部优点,为什么还要用servlet,用JSP代替servlet不就行了?
- 这个问题,好郁闷!
- 如何列出windows2000里的所有进程
- jbuilder9.0序列号和密码?
- 关于ant的问题
- 请问谁知道有现成的基于struts结构的网站地址
- Commons FileUpload通过parseRequest得到list为空
- 请问mysql如何实现向多个表同时插入数据?
begin
for c in (select s_personinfo.nextval as seq from dual) loop
Insert into TBPERSONINFO (IPERSONINFOID,VCPERSONCARD,VCPASSWORD,VCPERSONNAME,VCPERSIONSEX) values(c.seq ,'33000021','123456','小明','男',);
if c.seq = c.seq+500 then
return ;
end if;
end loop;
end;
IS
v_counter NUMBER(3) := 1;
Begin
LOOP
Insert into TBPERSONINFO (IPERSONINFOID,VCPERSONCARD,VCPASSWORD,VCPERSONNAME,VCPERSIONSEX) values (s_personinfo.nextval,'33000021','123456','小明','男',);
EXIT WHEN v_counter > 500;
END LOOP;
End;
sequence的值现为5000...
declare
begin
for c in (select s_personinfo.nextval as seq from dual) loop
Insert into TBPERSONINFO (IPERSONINFOID,VCPERSONCARD,VCPASSWORD,VCPERSONNAME,VCPERSIONSEX) values(c.seq ,'33000021','123456','小明','男',);
Insert into TBPERSONINFO (IPERSONINFOID,VCPERSONCARD,VCPASSWORD,VCPERSONNAME,VCPERSIONSEX) values(c.seq ,'33000021','123456','小明','男',); //插入两条数据,该怎么办呢...循环控制最好不要用此序列吧 if c.seq = c.seq+500 then
return ;
end if;
end loop;
end;
maxrecords constant int:=1000;
i int :=1;
begin
for i in 1..maxrecords loop
insert into UserInfo(UserID,login,password,firstName,lastName,ISADMINISTRATOR)
values(SYS_GUID(),TO_CHAR('9999'+i),'password','fristname','lastName','0');
end loop;
dbms_output.put_line(' 成功录入数据! ');
commit;
end;