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 16 Records

CHAPTER OBJECTIVES

In this chapter, you will learn about

• Record types

• Nested records

• Collections of records

Chapter 11, “Introduction to Cursors,” introduced 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 types. In addition, you will learn about records that contain collections and other records (called nested records) and collections of records.

Lab 16.1 Record Types

LAB OBJECTIVES ...

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