PL/SQL - BulkBind

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 156 of 166

BulkBind

What Is BulkBind? When it is used?

Total Answers and Comments: 1

Last Update: November 27, 2008 Asked by: bhaskar_1977

Sponsored Links

Best Rated Answer

—

Submitted by: saishradha

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

Above answer was rated as good by the following members:
ds_devi, dbandhanadham

November 26, 2008 21:42:04

saishradha

Member Since: November 2008 Contribution: 3

RE: BulkBind

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

Is this answer useful? Yes | No

2 0

Overall Rating: +2

Be Prepared for Tech Job Cuts

Even one of the most flourishing and possibly the strongest industries of the future are not experiencing the economic crunch. The tech industry is now experiencing massive job losses in different categories. Although you will still see innovations almost every day from the tech industry through th

User Name		Remember Me?
Password

Question Bank

Be Prepared for Tech Job Cuts