Answer / vijayakumar

its one type of fetching data. In oracle bulk collect pl/sql
engine tells sql engine to collect all rows at once.
It will improve the performance.

Answer / viswanath

To improve the performance of the application,oracle introduce bulk bind process using collections that is in this process we are putting all sql related vales into a collections.And in this collections we are performing insert,update at a time using for all these statements.

What does where 1/2 mean in sql?

0 Answers  

---

What is pragma exception and how, when, where us

5 Answers  

---

what is self join and how it works??

2 Answers   Infosys,

---

Name the tables where characteristics of Package, procedure and functions are stored ?

3 Answers  

---

Types of cursors and explanation each of them ?

4 Answers   DELL,

---

---

How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,

---

How to prepare for oracle pl sql certification?

0 Answers  

---

What are the benefits of stored procedures?

0 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

How can a pl sql block be executed?

0 Answers  

---

What are different types of sql commands?

0 Answers  

---

How packaged procedures and functions are called from the following?

2 Answers  

---