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 a sql statement?

0 Answers  

---

what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,

---

Explain clause in sql?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---

what is not null constraint? : Sql dba

0 Answers  

---

What are the events on which a database trigger can be based?

0 Answers  

---

How many primary keys can a table have?

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

---

what does it mean to have quoted_identifier on? : Sql dba

0 Answers  

---

What is indexing in sql and its types?

0 Answers  

---