To get the best performance during data (
) loads, the
PL/SQL Bulk Collect with Forall syntax is used. When one
of the value in the collection is deleted, the Forall
will not work. Shown below is an example of a deleted
value in a collection (index 5), with the use of
EXISTS(index) to process the existing elements of the
Oracle registered trademark of Oracle Corporation.