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';
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';
No comments:
Post a Comment