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".

What is a field in a database?

0 Answers  

---

What are the different types of triggers?

0 Answers  

---

what are the different types of joins?

4 Answers   Choice Solutions,

---

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  

---

How exception handling is done in advance pl/sql?

0 Answers  

---

What is mutating table?

11 Answers   Saama Tech,

---

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

---

Which table is left in left join?

0 Answers  

---

what are the different index configurations a table can have? : Sql dba

0 Answers  

---

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

---

trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 Answers   Oracle,

---

How do I add a primary key to a table?

0 Answers  

---