INSERT A TABLE DATA TO ANOTHER TABLE

 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

原文转自：http://www.ltesting.net