O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

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

Chapter Objectives

In this Chapter, you will learn about:

PL/SQL Tables

Varrays

Multilevel Collections

Through out this book you have explored different types of PL/SQL identifiers or variables that represent individual elements (for example, a variable that represents a grade of a particular student). However, often in your programs you want to have the ability to represent a group of elements (for example, the grades for a class of students). In order to support this technique, PL/SQL provides collection datatypes that work just like arrays available in other third-generation programming languages.

A collection is a group of elements of the same datatype. Each element is identified by a unique subscript that represents ...

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