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

Does view store data in sql?

0 Answers  

---

What are the different types of dbms?

0 Answers  

---

What is the difference between cross join and natural join?

0 Answers  

---

What is a table partition?

0 Answers  

---

which will fire first ? Trigger or Constraint

24 Answers   i2, IBM,

---

---

What's the procedure?

0 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

What is sharding in sql?

0 Answers  

---

How to move files from one directory to another in pl sql?

0 Answers  

---

Which is faster count (*) or count 1?

0 Answers  

---

what is transaction? : Sql dba

0 Answers  

---

What is sql and db2?

0 Answers  

---