SQL> update (select ename, dname
from emp e, dept d
where e.deptno = d.deptno
and empno = 7788)
set ename = 'X', dname = 'Y'
Scripts, Articles, Relevant for DBAs, Consultants, BI, Data Scientists and Developers