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;
/