plsql 存储过程 批量提交_Oracle 存储过程批量插入数据

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;

/