BULK COLLECT IN ORACLE AND IT’S ADVATAGE IN DATABASE Hello Everyone, In this blog we will discuss about BULK collect and its importance in Oracle Database. First we need to understand what is Bulk collect and how it’s improves the performance of a improving the speed of data retrieval. Before going through this I suggest you to please go through my previous blogs related with PL/SQL block for better understanding. BULK Collect: BULK COLLECT reduces context switches between SQL and PL/SQL engine and allows SQL engine to fetch the records at one time only. In simple word we can say BULK COLLECT SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data retrieval. BULK COLLECT fetches the record in BULK, the INTO clause should always contain a collection type variable. The main advantage of using BULK COLLECT is it increases the performance by reducing the interaction between SQL and PL/SQL engine to improve the performance of our...
Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.