Oracle Bulk Processing with BULK COLLECT and FORALL

Bulk Processing with BULK COLLECT and FORALL

In this article, I will cover the two most important of these features: BULK COLLECT and FORALL.

• BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data retrieval
• FORALL: INSERTs, UPDATEs, and DELETEs that use collections to change multiple rows of data very quickly

還不會先紀錄一下。

Oracle Magazine PL/SQL Columns

FORALL Statements for Sparse Collections