In this chapter, you will learn about
• PL/SQL tables
• Multilevel collections
Throughout this book you have explored different types of PL/SQL identifiers or variables that represent individual elements, such as a variable that represents a student’s grade. However, often in your programs you want to represent a group of elements such as the grades for a class of students. 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 its position in the collection. In this chapter you ...