declare
v_emp employees%Rowtype;
begin
select employeeid, firstname, salary
into v_emp.employeeid, v_emp.firstname, v_emp.salary
from employees
where employeeid = 109;
dbms_output.put_line(v_emp.employeeid || ' ' || v_emp.firstname || ' ' ||
v_emp.salary);
end;
v_emp employees%Rowtype;
begin
select employeeid, firstname, salary
into v_emp.employeeid, v_emp.firstname, v_emp.salary
from employees
where employeeid = 109;
dbms_output.put_line(v_emp.employeeid || ' ' || v_emp.firstname || ' ' ||
v_emp.salary);
end;