Nested Subselect in UPDATE statement | Oracle Community - Oracle ...

10 Mar 2010 ... UPDATE foo f SET ( x, y ) = ( SELECT * FROM ( SELECT b.x, b.y FROM ... work because the alias F is not known inside the nested subquery.

community.oracle.com