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 is aggregate function in sql?

0 Answers  

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

What is sql query optimization?

0 Answers  

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

What is raid? How does it help storage of databases?

0 Answers  

---

What are the types of views in sql?

0 Answers  

---

I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu

4 Answers   Adea,

---

how to write utl file pkg in SQL

1 Answers   Oracle,

---

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

0 Answers  

---

what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,

---

Why commit is not used in triggers?

0 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---