bulk collect « PL SQL Statements « Oracle PL/SQL Tutorial

22.17.bulk collect
22.17.1.select BULK COLLECT
22.17.2.Adding a limit to BULK COLLECT
22.17.3.To get the same result by using explicit cursors and bulk collect
22.17.4.Speeding Up Data Collection with Bulk Operations
22.17.5.Using the RETURNING ...BULK COLLECT clause to SELECT directly into a PL/SQL array
22.17.6.Demonstrate how to use DELETE with bulk processing.
22.17.7.Bulk processing with the FORALL statement
22.17.8.Bulk collect with non-cursor SELECT into multiple collections
22.17.9.Bulk collect from cursor with LIMIT option