Collections

What is collection?

A collection is a data type in oracle which can be compared to single dimensional array.

What are the types of collections ?

There are 3 types of collections :

1. Associate array
2. Nested Table
3. VARRAY

Advantages of collection :

• To track list of elements which are changed during the execution of the program
• It can be used with FORALL and BULK COLLECT to improve the DML performance in PL/SQL
• It can be used to cache the static database information which are queried more frequently during session or program. This will improve the performance.