INSERT A TABLE DATA TO ANOTHER TABLEWindows系统 -电脑资料

    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