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