December 2002
Intermediate to advanced
928 pages
85h 29m
English
Nested records are records contained in fields that are records themselves. Nesting records is a powerful way to normalize data structures and hide complexity within PL/SQL programs. For example:
DECLARE
-- Define a record.
TYPE phone_rectype IS RECORD (
area_code VARCHAR2(3),
exchange VARCHAR2(3),
phn_number VARCHAR2(4),
extension VARCHAR2(4));
-- Define a record composed of records.
TYPE contact_rectype IS RECORD (
day_phone# phone_rectype,
eve_phone# phone_rectype,
cell_phone# phone_rectype);
-- Declare a variable for the nested record.
auth_rep_info_rec contact_rectype;
BEGIN