Answer / suresh kumar somayajula

V-Array is an Ordered set of elements.It's having Maximum
size and you can't delete individual elements. V-Arrays are
dense.

Nested Table is an un-orderes set of elements.It doesn't
have maximum size and you can delete individual elements
from Nested Tables . Nested Table can be Parse.

Answer / manoranjan sethy

If you want to declare fixed element then use varray.
If you want to declare any number of element at run time then use nested table.

What are the dml statements?

0 Answers  

---

How to rename a column in the output of sql query?

0 Answers  

---

Are sql database names case sensitive?

0 Answers  

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

What is pl/sql and what is it used for?

4 Answers  

---

---

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

---

What is the best sql course?

0 Answers  

---

how can you create an empty table from an existing table? : Sql dba

0 Answers  

---

What is mutating sql table?

0 Answers  

---

what is indexing, searching and user interface?

1 Answers   HCL,

---

Can we alter stored procedure?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---