O'Reilly logo

Oracle Advanced PL/SQL Developer Professional Guide by Saurabh Gupta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required