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

2010年3月10日 - 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