BulkBind

What Is BulkBind? When it is used?

Questions by bhaskar_1977

Showing Answers 1 - 3 of 3 Answers

saishradha

  • Nov 26th, 2008
 

Bulk Bind is the facilty through which we can INSERT, UPDATE, DELETE or SELECT from records from a table in bulk rather than multiple individual statments..
Suppose you have 10 inserts to be made so you use 10 INSERT into statments to do this.
Instead of this you can you FOR ALL PL/SQL statement to perform all 10 inserts once at a time.

Morever if you have to issue 10 select statements you should rather use BULK COLLECT to perform this operation..
Another adavantage of BulkBInd is that you can save time on context switching between transactions.

Jai SaiRam

Give your answer:

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

 

Related Answered Questions