beingchinmay
New member
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:
Code:
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