SQL Statements Summary

-- multi-tables updating

update (select /*+bypass_ujvc*/

      a.v1 oldV1, b.v1 newV1 

      from t1 a, t2 b

            where a.id = b.id)

   set oldV1 = newV1;