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.

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

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.

Answer / suresh somayajula

Binding of entire collection at once is called as " Bulk

Bind".

How do you create a db file?

0 Answers  

---

How will you delete a particular row from a Table?

7 Answers   Cap Gemini,

---

What are the new features in Oracle 10g. Compared to Oracle 9i?

1 Answers   Polaris,

---

What is mdf ldf and ndf?

0 Answers  

---

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

---

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

---

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

---

How do you explain an index number?

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

How do I find duplicates in two columns?

0 Answers  

---

what is the difference between truncate and delete statement? : Transact sql

0 Answers  

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

0 Answers  

---