Monday, 4 February 2013

ORA-01767: UPDATE ... SET expression must be a subquery


update scott.emp set (empno,ename)=(111,'scott1') where ename='SCOTT';

issue: You cannot put multiple set clause columns as a expression. You have put them in a sub query like below.


update scott.emp set (empno,ename)=(select 111,'scott1' from dual) where ename='SCOTT';