Merge into Oracle's Saveoruapdate

1. Initial data:

Sql> select * from A; ID                     NAME--------------------------------------------1                      1sql> select * from B; ID                     NAME--------------------------------------------1                      211                     11

2, Target: 1) The ID in table A is the same as the ID in B table, the update a.name to b.name; 2) the ID in table B is not in a table, copy the records of B table, insert into a table

3. Function Realization:

Merge into a A with B b on (a.id = b.id)--on is the match condition when matched then--Update a.nameupdate Set a.name = b.name where 1=1 when matching-- Here you can add the where condition when not matched then--copy and insert Binsert values (b.id,b.name) where 1=1

　　

Merge into Oracle's Saveoruapdate