To get the best performance during data ( ETL ) 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 collection. |
74527