Answer / kesava

COLLECTION:
Collection contains number of user defined types which is
stored number of data items in Single unit.
Why introduce Collection:
--->When ever we are using cursor memory area control does not get it back from Active set Area.
=====>when ever we are using Collection we are operating
element and also we are moving forward and reverse directions with in memory are using Collection
collection Types:
index by Table
Nested Table
Varray

Is sql difficult?

0 Answers  

---

what is meant by nl2br()? : Sql dba

0 Answers  

---

What is orm in sql?

0 Answers  

---

Explain the uses of database trigger.

0 Answers  

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

---

What is the difference between Union and Union all. Which is faster.

0 Answers  

---

What is pessimistic concurrency control? : Transact sql

0 Answers  

---

What are the different dcl commands in sql?

0 Answers  

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,

---

What is a pl/sql block?

0 Answers  

---

Explain table and field in sql?

0 Answers  

---