Chapter 3. Using Collections

Conceptually, "array" has been a colloquial term in programming glossaries. It refers to a list of similar elements. In Oracle, an array is known by the name, collection. A collection consists of a list of elements of the same type, where each element can be identified by its index or subscript.

A collection works on the same philosophy as an array, a queue, or a linked list works. Collections provide wide scope of usability and applications in database programming. Besides being a performance booster, collections can also be used for data caching mechanisms in programs. It can also be used as database columns, type attributes or subprogram parameters. In this chapter, we shall perform a detailed study on collections, ...

Get Oracle Advanced PL/SQL Developer Professional Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.