A RECORD is a collection of data items, which differ from each in other in datatype, but are logically related. For example, an employee record with name, age, address, and telephone number. These are all part of employee record but have different datatypes.
In PL/SQL, the record type is defined first and then the record of that type is declared as follows:
TYPE emp_record_tyPe is RECORD
(emp_name varchar2(50),
emp_age number(2),
emp_address varchar2(100).
emp_tel_no number(10));
emp_record emp_record_type;
We have defined the record type by the name emp_record_type and then declared a record, emp_record, of that type.
