Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is bulk bind

Question Posted / husenaiahb

Answers were Sorted based on User's Feedback



what is bulk bind..

Answer / guru

A DML statement can transfer all the elements of a
collection in a single operation, a process known as bulk
binding. If the collection has 20 elements, bulk binding
lets you perform the equivalent of 20 SELECT, INSERT,
UPDATE, or DELETE statements using a single operation. This
technique improves performance by minimizing the number of
context switches between the PL/SQL and SQL engines. With
bulk binds, entire collections, not just individual
elements, are passed back and forth.

Is This Answer Correct ?    5 Yes 1 No

what is bulk bind..

Answer / 24/07/07

Bulk Bind is technique where instead of multiple individual
SELECT, INSERT, UPDATEE & DELETE statements are executed to
retrive from or store data in, at table all of the
opeartions are carried out at once in bulk.

Regard's
Srinivas Ganamur

Is This Answer Correct ?    4 Yes 1 No

what is bulk bind..

Answer / roopesh kumar

Bulk binding is a way for performance tunning i.e. it will
complete the whole process in once remove the contaxt
switching of sql to pl-sql & pl-sql to sql.

Is This Answer Correct ?    1 Yes 1 No

what is bulk bind..

Answer / suresh somayajula

Binding of entire collection at once is called as " Bulk

Bind".

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What port does sql server use?

0 Answers  

How do I get sql certification?

0 Answers  

What is the left table in sql?

0 Answers  

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

How delete a row in sql?

0 Answers  

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,

What is difference between stored procedure and trigger?

0 Answers  

Is sql an operating system?

0 Answers  

wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,

What are Global Temporary tables

3 Answers   IBM, TCS,

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories