Oracle中的Bulk Collect和FORALL

http://www.oracle.com/technetwork/issue-archive/2012/12-sep/o52plsql-1709862.html

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