Login/RegisterTechnical Discussion :: Oracle PLSQL
Home > Technical Interview Q&A > Oracle PLSQL > Discussion
2 / 31
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.
