Home What is Oracle? Oracle Training Tutorials for Beginners Difference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11g Ora 28001 The Password Has Expired Error Cache and Nocache in Oracle Sequence BR*Tools Documentation ORA-01455: Converting Column Overflows Integer Datatype Oracle Wait Events Interview Questions Difference Between Primary, Secondary and Clustered Indexes in DBMS Difference Between Hot and Cold Backup Oracle Partitioning Interview Questions Update Statement Works in Oracle Architecture Differences Between SAP HANA and Oracle Group Functions Ignore Null Values in Processed Column ORA-10458: Standby Database Requires Recovery Oracle Interview Questions

Difference between Bulk Collect and Forall

Updated May 18, 2018

Bulk Collect vs Forall

Hello Experts,

May I know what is the difference between Bulk Collect and FORALL?

Suppose I am inserting 10000 records due to some issue few records are not inserted, how to find which records are not inserted, which method follow to find.

Please assist here,

Thanks in advance,

Comments

20 Apr 2017 12:07 pm Sushma Helpful Answer

BULK COLLECT is used to fetch the records through the cursor. Bulk collect extract data from multiple rows in a single fetch thus improving the speed of data retrieval. It also gives a command to PL/SQL engine for bulk-binding the input collections before sending them to SQL engine.
FORALL is used to perform DML operation of the fetched data. It quickly INSERTs, UPDATEs, and DELETEs that use collections to change multiple rows of data. FORALL also command the PL/SQL engine to bulk-bind input collections before sending them to the SQL engine.