Example : Multiple data update in single query in Oracle

For Multiple data update in single query in Oracle , following example can be used:


Update Table1 a
set (a.NAME) = (select b.NAME
                                  from Table2 b
                                  where b.id = a.id)