Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table t1 as 
    select rownum id, 'name '||rownum name from dual connect by level<=3
3 rows affected

create table t2 as select * from t1
3 rows affected

begin
    delete t2 where id=3;
    update t2 set name='*'||name;
    insert into t2 values (4, '*name 4');  
    insert into t1 values (5, 'name 5');  
end;
/
1 rows affected

(select * from t1 minus select * from t2) union all
(select * from t2 minus select * from t1)


ID
NAME


1
name 1

2
name 2

3
name 3

5
name 5

1
*name 1

2
*name 2

4
*name 4


merge into t1 using (
    select coalesce (t2.id, t1.id) id, coalesce (t2.name, 'deleted') name
    from t2 full join t1 on t1.id = t2.id
) src on (src.id = t1.id)
when not matched then 
    insert values (src.id, src.name)
when matched then 
    update set t1.name = src.name
    delete where src.name = 'deleted'
5 rows affected

(select * from t1 minus select * from t2) union all
(select * from t2 minus select * from t1)