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

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

---

What are the parts of a sql statement?

0 Answers  

---

---

Are subqueries faster than joins?

0 Answers  

---

What is the difference between a primary key and a unique key?

0 Answers  

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

0 Answers  

---

what is datawarehouse? : Sql dba

0 Answers  

---

How do I run sql?

0 Answers  

---

Can a table have no primary key?

0 Answers  

---

how to calculate expressions with sql statements? : Sql dba

0 Answers  

---