UPDATE - Oracle Software Downloads | Oracle Technology Network | Oracle

If you specify multiple columns in the update_ set_clause, then the subquery must return as many values ...

download.oracle.com