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

When are we going to use truncate and delete?

0 Answers  

---

how to return query output in html format? : Sql dba

0 Answers  

---

Is natural join same as inner join?

0 Answers  

---

What is the difference between anonymous block and named block or stored procedure?

8 Answers  

---

What language is oracle sql developer?

0 Answers  

---

---

what is cursor procedure

1 Answers   iGate,

---

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

---

What is linq to sql?

0 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

How does left join work in sql?

0 Answers  

---

what is data manipulation language? : Sql dba

0 Answers  

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---