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.

how can we repair a mysql table? : Sql dba

0 Answers  

---

What is cascade in sql?

0 Answers  

---

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

---

How to convert comma separated string to array in pl/sql?

0 Answers  

---

Whis is not false in primary key?

0 Answers   Fintellix,

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

how to delete an existing column in a table? : Sql dba

0 Answers  

---

what are date and time data types? : Sql dba

0 Answers  

---

What are pl sql data types?

0 Answers  

---

how to check myisam tables for errors? : Sql dba

0 Answers  

---

Is sql a case sensitive language?

0 Answers  

---

How do you create a unique index?

0 Answers  

---