Oracle 23c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table emp_salary ( 
  empno      number primary key,
  salary     number
);
create table emp_commission ( 
  empno      number primary key,
  commission number
);
insert into emp_salary values (99, 1000);
1 rows affected

insert into emp_commission values (99, 100);
1 rows affected

commit;
create view emp as
 select * from emp_salary
 join emp_commission
 using ( empno )
;
update emp
   set commission=commission+42
   where empno=99
   and salary=1000 and commission=100
;
1 rows affected

declare
 -- using autonomous transaction to simulate a concurrent transaction 
 pragma autonomous_transaction;
begin
 update emp
   set salary=salary+42
   where empno=99
   and salary=1000 and commission=100
 ;
 commit;
end;
/
1 rows affected

commit;
select * from emp;


EMPNO
SALARY
COMMISSION


99
1042
142