oracle 存储过程批量插入大量数据
declare numCount number; userName varchar2(512); email varchar2(512); markComment varchar2(512); maxId number; begin numCount := 1; userName := 'userName number : .'; email := 'email number : '; markComment := 'markComment number .'; for i in 1 .. 1000 loop for j in 1 .. 1000 loop insert into userInfo (userId,userName,email,markComment) values (numCount,userName||numCount,email||numCount,markComment||numCount); numCount := numCount + 1; end loop; commit; end loop; end; /原文链接:https://www.f2er.com/oracle/213246.html