Hello,
please, how can I efficiently update the selected row (I don't mean to declare a cursor for update)?
declare
dept_row dept%rowtype;
begin
select * into dept_row from dept where deptno = 10 for update;
dept_row.dname := 'NEWDNAME';
--now I just want to update the selected record
--this works
update dept set row = dept_row where deptno=dept_row.deptno;
--but in my real usecase there is a composite primary key consisting of more columns, so I would like to do something like this
update dept set row = dept_row where rowid = dept_row.rowid;
--or
update dept set row = dept_row where row = dept_row;
end;
Thanks a lot,
Pavel