Collection Types in Object database systems

Collection types in object relational database systems, Collection types VARRAY, Nested Tables, and Associative Arrays in Oracle

Collection Types

A collection is an ordered group of elements of same type. The purpose of collection type is to support multiple values for one attribute [variable]. For example, other programming languages support the collection types array, lists, sets, bags, trees etc. To extend these features in database applications, PL/SQL provides the following collection types;

• Nested Tables

• VARRAYs (Varying arrays)

• Associative Arrays

***************

Go to Object database systems page