作者:依love依CENE_790 | 来源:互联网 | 2018-07-13 23:29
Oracle存储过程for语句用法,并且每500条提交一次。createorreplaceprocedurePS_TESTISbeginFORiIN1..10000LOOP--deletefromtestwherenameto_char(i);
Oracle存储过程for语句用法,并且每500条提交一次。 create or replace procedure PS_TEST IS begin FOR i IN 1..10000 LOOP --delete from test where name=to_char(i); - INSERT INTO test VALUES(to_char(i),i+2); IF MOD(i,500) = 0 THEN COMMIT; END IF;
Oracle存储过程for语句用法,并且每500条提交一次。
create or replace procedure PS_TEST IS
begin
FOR i IN 1..10000
LOOP
--delete from test where name=to_char(i);
-
INSERT INTO test VALUES(to_char(i),i+2);
IF MOD(i,500) = 0 THEN
COMMIT;
END IF;
END LOOP;
COMMIT;
end PS_TEST;