Cursor

[RCBMapsParticipante]

Obrigado ultilizei o FORALL éra exatamente o que eu queria.

Segue um exemplo do que eu criei.

DECLARE
CURSOR classes_1 IS
SELECT *
FROM classes;

TYPE fetch_array IS TABLE OF classes%ROWTYPE;
s_array fetch_array;
BEGIN
OPEN classes_1;
LOOP
FETCH classes_1 BULK COLLECT INTO s_array LIMIT 1000;

FORALL i IN 1..s_array.COUNT
INSERT INTO classes_bkp VALUES s_array(i);

EXIT WHEN classes_1%NOTFOUND;

END LOOP;
CLOSE classes_1;
COMMIT;
END;