Hi I am trying to update a col on a large table (1.7mil rows)
I have this stored proc and I dont know how to conver the folloing code to use a forall bulkbind to speed up my update any sugestions or solutions?
---------------------------------
CURSOR cursor_a
IS
SELECT
a.field1, b.field2
FROM schema1.table1 a, schema2.table2 b
WHERE b.field3 = a.field3;
--
BEGIN

FOR curs_rec IN cursor_a
UPDATE
schema1.table1 a
SET a.field2 = curs_rec.field2
WWHERE a.field1 = curs_rec.field1;

COMMIT;
--------------------------------------