Records in PL/SQL

Records are composite data structures whose fields can have different datatypes. You
can use records to hold related items and pass them to subprograms with a single parameter.

DECLARE
TYPE timerec IS RECORD (hours SMALLINT, minutes SMALLINT);
TYPE meetin_typ IS RECORD (
date_held DATE,
duration timerec, -- nested record
location VARCHAR2(20),
purpose VARCHAR2(50));
BEGIN
NULL;
END;
/