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.

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

What is trigger types in sql?

0 Answers  

---

What is record variable?

0 Answers  

---

what are the features and advantages of object-oriented programming? : Sql dba

0 Answers  

---

What is sqlca in db2?

0 Answers  

---

---

How to pronounce postgresql?

0 Answers  

---

Explain what is dbms?

0 Answers  

---

How to start the command-line sql*plus?

0 Answers  

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

Explain ddl statements in pl/sql?

0 Answers  

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---