O'Reilly logo

Oracle Database 11g PL/SQL Programming by Michael McLaughlin

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 7Collections

There are three types of collections in the Oracle Database 11g family of products. They are the varray, nested table, and associative array datatypes. Collections are powerful structures because they enable you to develop programs that manage large sets of data in memory.

You can build collections of any SQL or PL/SQL datatype. Collections of SQL datatypes work in both SQL and PL/SQL environments but collections of PL/SQL datatypes do not. They only work in PL/SQL.

This chapter explains how to define and work with collections in PL/SQL. There is also some coverage of using collections as database columns. It covers these topics:

Collection types

Varrays

Nested tables

Associative arrays

Collection set operators

Collection ...

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