O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, 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 15 Collections

CHAPTER OBJECTIVES

In this chapter, you will learn about

• PL/SQL tables

• Varrays

• 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 ...

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