dev5000

 Profile Answers by dev5000 

• Dec 26th, 2007

 

It is kind of datatype.
Collection is nothing but a convenient way to manipulate many variables at once.
There are 3 types of collection.
1. INDEX BY TABLE
2. NESTED TABLE
3. VARRAYS

kirangsv

 Profile Answers by kirangsv 

• Jan 6th, 2008

 

A collection can be loosely defined as a group of ordered elements, all of the same type that allows programmatic access to its elements through an index. Commonly used collection types used in the programming world include arrays, maps, and lists. Probably the biggest advantage a collection can provide is improved application performance. Developers utilize collections to 'cache' static data that needs to be regularly accessed. This results in reduced calls to a database.
Oracle provides three types of PL/SQL collections: nested tables, varrays, and associative arrays. We will review each of these collection types in turn. But first, let's take a quick look at traditional approaches to collections programming.