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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
