ex: PLSQL
for i in 1 .. n loop
insert into ...;
if mod(i, 2000) = 0 then
commit;
end ;
end loop;
或者:存储过程方式:
CREATE OR REPLACE PROCEDURE insert1w
(
o_retvalue OUT NUMBER
)
AS
cnt number(10);
v_message varchar(100);
v_index number(10);
BEGIN
o_retvalue := 0;
cnt:=1;
v_index:=111;
loop
v_index:=v_index+1;
insert into myTest(id,aa,bb) values (v_index,11,22);
cnt:=cnt+1;
if cnt>100 then
exit;
end if;
end loop;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
v_message := SQLCODE || ':' || SQLERRM;
o_retvalue := SQLCODE;
END;
以exec insert1w执行.