Updating multiple columns using forall

Posted by / 12-Aug-2017 11:34

FORALL update using SET ROW. We have avoided both the primary key updates and the redundant updates against columns that do not change.

In addition, we will copy the transformed data into a new array of records based on just the two columns we wish to update.

*/ 43 aa_updates(i):= aa_rows(i).name; 44 aa_updates(i):= aa_rows(i).type; 45 46 END LOOP; 47 48 /* 49 updating multiple columns using forall-45updating multiple columns using forall-32updating multiple columns using forall-23

On the face of it, this feature appears to be quite useful, especially in reducing the amount of code we need to write and maintain.