15

Collections

Throughout 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 for 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). To support this technique, PL/SQL provides collection data types that work just like arrays available in other third-generation programming languages.

A collection is a group of elements of the same data type. Each element is identified by ...

Get Oracle PL/SQL by Example, 6th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.