In Oracle, I would like to perform a correlated subquery where
multiple columns are specified in the set clause and those columns are
selected by the subquery. For example:
UPDATE table1 a
SET (a.column1, a.column2) = (SELECT b.column1, b.column2 FROM table2
b WHERE a.id=b.id)
WHERE
This is a completely Oracle-specific syntax I've never seen before, and
apparently resembles an UPDATE FROM - ticket #2166 has been updated to see if
it can be part of the solution when we implement the more common UPDATE FROM
extension.
Unfortunately this syntax is not supported. Your