COLLECTIONS

Main diff between nested table and varray are..
1. Varrays have maximum size but nested table do not have maximum size
2.
Nested tables always dense, but varrays sparse. Elements of nested table can be deleted but varrays cant be deleted.
3.
Varrays stored in database in same table space but nested table data store out of database line in
separate table space.
4. Varrays data in database store as unique consecutive
subscripts but nested table not.

  1 User has rated as useful.

  

Login to rate this answer.

diff between nested table and varrays.

1.varrays will have max size but nested table do not have.

2.varrays stored in database in same table space but nested table in diff table space.

3.varrays are always dense but nested table can be sparse . we cant delete indisual elments of varrays.

4.varrays stored in database maintain there ordering and subscripts.

exceptions related to collections are...

1.collection_is_null

2.collection subscript beyond count

3.collection subscript outside limit

4.no_data_found .

these are more common exceptions  related to collections.