Mylo

• Dec 15th, 2012

 

Bulk binding reduces the context switches between SQL and pl/SQL engines. It enhances the performance but thr memory consumption would be high.

amala

• Jun 24th, 2015

 

It retreives multiple rows with a single fetch...It increases the performance by reducing no.of context switches

sachin rasal

• Nov 12th, 2015

 

A new feature called "bulk binds" was added to PL/SQL back in Oracle 8i. Bulk binds enable a PL/SQL program to fetch many rows from a cursor in one call instead of fetching one row at a time. Bulk binds also allow many similar DML statements to be executed with one call instead of requiring a separate call for each. For certain types of PL/SQL programs, using bulk binds will reduce CPU usage and make the code run faster.