Problems to UPDATE several columns with a WITH...SELECT subquery
94828Aug 3 2010 — edited Aug 5 2010Hi,
This statement works fine:
UPDATE scott.dept
SET ( deptno ) = ( WITH gaga AS
( SELECT 1
FROM DUAL )
SELECT deptno
FROM gaga )
/
The second statement gives an error ORA-01767: UPDATE ... SET expression must be a subquery:
UPDATE scott.dept
SET ( deptno, dname ) = ( WITH gaga AS
( SELECT 1,
'CHANGED'
FROM DUAL )
SELECT deptno,
dname
FROM gaga )
/
What is wrong? Is it a restriction of Oracle 9i?
Thank you,
Heinz