Chapter 5. Records
A record, a construct structurally and conceptually similar to a row in a database table, is a named collection of elements. Each element, or field, has its own name, datatype, and value. The record itself doesn’t have a value; it’s simply a named pointer to the collection of fields. One of the main advantages of records is their ability to simplify your code by grouping disparate elements into a logical unit. For example, rather than passing five parameters to a procedure, you can pass just one record that contains five fields. This chapter tests your ability to define a record’s structure, create and use record variables, and set and retrieve values for a record’s fields.
Which of the following statements about a PL/SQL record are true, and which are false?
Which of the following lines of code demonstrate the correct method for referencing a string field named “favorite_flavor” in a record named “ice_cream”?
Declare a record that has the same structure as the ...