| Associate array | Nested Table | Varray |
| Single dimensional | Single dimensional | Single dimensional |
| Unbounded | Unbounded | Bounded. The row limit has to be specified while declaring |
| Sparse collection. | Initially Dense collection. Later on can be made sparce by deleting the element in nested table | Dense collections |
| Can only be used in PL/SQL | Can be used both in PL/SQL as well as a column of a database table. | Can be used both in PL/SQL as well as a column of a database table. |
| - | Nested table is multiset. I.e. when you store & retrieve elements in Nested table its order is not preserved. | The order is preserved while storing and extracting the elements. |
Friday, July 1, 2011
What are the difference between assoicate array, nested table and varray ?
Subscribe to:
Comments (Atom)