15일차 # 6-14: Update with records

        ...

update retired_emps

set ROW = emp_rec <-- ROW 키워드에 주목

where empno = &emp_no;

...

----------------------

set serveroutput on

select * from e1

where rownum = 1;

declare

 emp_rec e1%rowtype;

begin

 select * into emp_rec

 from e1

 where rownum = 1;

 emp_rec.comm := 20;

 emp_rec.deptno := 10;

 update e1

 set ROW = emp_rec

 where empno = emp_rec.empno;

 commit;

end;

/

select * from e1;