Search
Ashish sinha
- May 1, 2020
- 3 min
PL/SQL - Bulk Collect
Bulk collect is one of my favourite features in PL/SQL programming. It gains significance when you require better performing code using collections to collect very large number of rows. larger the number of rows to be collected better is the performance using bulk collect. During an Oracle bulk collect, the SQL engine retrieves all the rows and loads them into the collection before it switches back to the PL/SQL engine. When rows are retrieved using Oracle bulk collect, t
19 views0 comments