PL/SQL Collections and Records

TABLE and VARRAY PL/SQL datatypes allow the user to declare nested tables, associate arrays, and variable-size arrays which can be used to model collection types such as arrays, bags, lists, nested tables, sets and trees used in most of the programming techniques.

Collections and records are composite types that have internal components that can be manipulated individually such as Elements of an

• array


• record


• table

A collection is an ordered group of elements, all of the same type. Its similar to lists,arrays. Each element is addressed by a unique subscript.

PL/SQL offers these collection types:

• Associate Arrays


• Nested tables


• Varrays