Oracle Database 12c PL/SQL Programming

CHAPTER

6

Collections

Collections are arrays and lists—at least, that’s the way they’ve been labeled since the advent of Java. An array is a collection of a fixed number of elements that share the same data type. A list is a collection of any number of elements that share the same data type. A list is generally more flexible than an array because you don’t have to know before you create a list how many elements belong in the collection

Oracle Database 12c provides you with a very powerful collection framework, and the framework lets you create collections in a SQL or PL/SQL context. You can use the collection framework to create the equivalent ...