Here We are Showing how to use composite Record type

DECLARE
    TYPE emp_record_type is RECORD
        (name   char(20),
         sal         number(10),
         hiredate        date);
   emp_rec    emp_record_type;
BEGIN
    select ename, sal,hire_date
    into emp_record
    from Scott.emp
    where employee_id = 1047;
         dbms_output.put_line(emp_rec.name||'        '||
         emp_rec.sal||'       '||
         emp_rec.hiredate);
  END;