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 many unique keys can a table have?

0 Answers  

---

What are two statement types in sql?

0 Answers  

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  

---

what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,

---

How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  

---

What does pragma mean?

0 Answers  

---

how can we know the count/number of elements of an array? : Sql dba

0 Answers  

---

How do you go back in sql?

0 Answers  

---

Are views faster than queries?

0 Answers  

---

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---

What is the location of pre_defined_functions.

0 Answers  

---

What will you get by the cursor attribute sql%found?

0 Answers  

---