set serveroutput on;
declare
TYPE t_emprec is RECORD(
NAME emp.ename%type,
ID emp.empno%type,
job emp.job%type);
v_temp t_emprec;
begin
select ename, empno, job
into v_temp from emp
where empno = 7521;
dbms_output.put_line(v_temp.Name);
dbms_output.put_line(v_temp.ID);
dbms_output.put_line(v_temp.job);
end;
/