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 19. Records

Chapter Objectives

In this Chapter, you will learn about:

Records

Nested Records

Collections of Records

In Chapter 9, you were briefly introduced to the concept of a record type. You have learned that a record is a composite data structure that allows you to combine various yet related data into a logical unit. You have also learned that PL/SQL supports three kinds of record types: table based, cursor based, and user defined. In this chapter, you will revisit table-based and cursor-based record types and learn about user-defined record type. In addition, you will learn about records that contain collections and other records (called nested records) and collections of records.

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