16

Records

In Chapter 11, “Introduction to Cursors,” you were introduced to the concept of a record type. You discovered that a record is a composite data structure that allows you to combine different yet related data into a logical unit, and you learned how table-based and cursor-based records may be used in cursor processing.

In this chapter, you will continue exploring record types supported by PL/SQL and learn about a user-defined record type. In addition, you will learn about records that contain collections and other records (called nested records) and collections of records.

Lab 16.1: User-Defined Records

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.