Technical Discussion :: SQL
Home > Technical Interview Q&A > SQL > Discussion
3 / 108
What is bulk collect clause?
Answer:
Oracle bulk collect, the SQL engine retrieves all the rows and loads them into the collection and switches back to the PL/SQL engine. When rows are retrieved using Oracle bulk collect, they are retrieved with only two context switches.
Asked In ::
Prudvi Kumar M
23 Feb, 2019 5:07 AM
Oracle bulk collect, the SQL engine retrieves all the rows and loads them into the collection and switches back to the PL/SQL engine. When rows are retrieved using Oracle bulk collect, they are retrieved with only two context switches.