DECLARE
CURSOR cur_1 IS
 SELECT * FROM orhan2;
TYPE fetch_1 IS TABLE OF cur_1%ROWTYPE;
v_1 fetch_1;
BEGIN
 DBMS_OUTPUT.put_line ('Start:' || SYSTIMESTAMP);
 OPEN cur_1;
 LOOP
 FETCH cur_1 BULK COLLECT INTO v_1 LIMIT 10000;
FORALL i IN 1..v_1.COUNT
 INSERT INTO orhan1 VALUES v_1(i);
EXIT WHEN cur_1%NOTFOUND;
 END LOOP;
 CLOSE cur_1;
COMMIT;
 DBMS_OUTPUT.put_line ('End:' || SYSTIMESTAMP);
EXCEPTION
 WHEN NO_DATA_FOUND THEN
 DBMS_OUTPUT.put_line (SQLERRM);
 WHEN OTHERS THEN
 DBMS_OUTPUT.put_line (SQLERRM);
END;
Reklam