; -- Use Oracle's FORALL statement for bulk insertion FORALL i IN 1 .. i0.count INSERT INTO actor (first_name, last_name) VALUES (i0(i), i1(i)) RETURNING id, last_update BULK COLLECT INTO o0, o1; -- Fetch the update count ? : returns the data as it was after any default or the in case that type of statement was executed, but before trigger generated values FINAL : returns the data as it was actually inserted, i.e.