O'Reilly logo

Oracle Database 11g PL/SQL Programming Workbook by John M. Harper, 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

Collections are arrays and lists—at least, that’s the way we’ve label them since the advent of Java. A collection in an Oracle database acts like an array when you define it as a varray, and it acts like a list when you define it as a nested table or an associative array. The varray and nested table are SQL data types, and they’re indexed initially by sequential integers. This typically means they’re densely populated structures because they don’t have gaps, which is an exception that we’ll discuss in this chapter. Associative arrays differ from nested table because they can have sequential or nonsequential numeric indexes, or string indexes. They’re sparsely populated structures because they may have gaps in their index ...

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