Bulk Collect

Oracle Bulk Collect is recommended to use for handling large number of rows. Note that, the larger the number of rows you will collect, the more performance improvement you will achieve.

For better understanding take a look at the examples bellow.

1. Bulk Collect can be coded without CURSOR loop.

2. To improve performance of upper example you should use APPEND_VALUE hint.

3. A little bit complex example of using Bulk Collect. Example: