PL/SQL - Chunk INSERT

SELECT Query : SELECT a,b,c,d,e FROM TABLE t2, TABLE t3, TABLE t4 WHERE conditions ;
INSERT Query : INSERT INTO TABLE t1 (SELECT a,b,c,d,e FROM TABLE t2, TABLE t3, TABLE t4 WHERE conditions)



// Batch Process 0-500
INSERT INTO TABLE t1
(
    SELECT * FROM
    ( SELECT a.*, ROWNUM rnum FROM
        ( SELECT a,b,c,d,e FROM TABLE t2, TABLE t3, TABLE t4 WHERE conditions ) a
      WHERE ROWNUM <= 500 )
    WHERE rnum  >= 0;
)

// Batch Process 501-1000
INSERT INTO TABLE t1
(
    SELECT * FROM
    ( SELECT a.*, ROWNUM rnum FROM
        ( SELECT a,b,c,d,e FROM TABLE t2, TABLE t3, TABLE t4 WHERE conditions ) a
      WHERE ROWNUM <= 1000 )
    WHERE rnum  >= 501;
)