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