Oracle union queries and updates a table field's SQL statement

Updating a field is simple and easy to understand: Update TableA a set a.name= (select name from TableB B where a.id=b.id) is more verbose when updating multiple fields: Update TableA a set A.name= (select name from TableB b where a.id=b.id), a.age= (select age from TableB b where a.id=b.id) if there are too many fields to update, it is too messy to write, and Duplicate query efficiency is also greatly reduced, you can use this way: MERGE into TableA A USING TableB B on (a.id = b.id) When matched then UPDATE SET a.name=b.name,a.a Ge=b.age,a.title=b.title

This article from "Empty" blog, declined reprint!

Oracle union queries and updates a table field's SQL statement