declare
v_count number;
CURSOR C1 IS
SELECT BADGE_NO,START_TIME FROM OVERTIME_APP_LP
;
BEGIN
v_count := 0;
FOR C1_REC IN C1 LOOP
INSERT INTO OVERTIME_APP
SELECT * FROM OVERTIME_APP_LP
WHERE BADGE_NO = C1_REC.BADGE_NO
AND START_TIME = C1_REC.START_TIME;
v_count := v_count + 1;
IF v_count = 1000 THEN
COMMIT;
v_count := 0;
END IF;
END LOOP;
COMMIT;
END;
1.OVERTIME_APP_LP 要有index
2.目標overtime_app 不要有過多的index,trigger
延伸阅读
文章来源于领测软件测试网 https://www.ltesting.net/