Bulk binding

What are the advantages of bulk binding in PL/SQL?

Questions by sidd_130

Showing Answers 1 - 3 of 3 Answers


  • 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.

  Was this answer useful?  Yes


  • 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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions