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