Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table domains( id int, name varchar2(50), code varchar2(50), description varchar2(50));
insert into domains values(1,'Domain A','D.A.','This is Domain A');
 
1 rows affected

merge into domains A
using 
(select 2 id, 'Domain A' name, 'D.A.' code, 'This is Domain A' description from domains) b
   on ( a.name = b.name )
 when not matched then insert( a.id, a.name, a.code, a.description ) 
                       values( b.id, b.name, b.code, b.description );
 
select * from domains;


ID
NAME
CODE
DESCRIPTION


1
Domain A
D.A.
This is Domain A


delete domains;
1 rows affected

insert into domains values(1,'Domain A','D.A.','This is Domain A');
1 rows affected

merge into domains A
using 
(select 2 id, 'Domain B' name, 'D.B.' code, 'This is Domain B' description from domains) b
   on ( a.name = b.name )
 when not matched then insert( a.id, a.name, a.code, a.description ) 
                       values( b.id, b.name, b.code, b.description );
1 rows affected

select * from domains;


ID
NAME
CODE
DESCRIPTION


1
Domain A
D.A.
This is Domain A

2
Domain B
D.B.
This is Domain B


delete domains;
2 rows affected

insert into domains values(1,'Domain A','D.A.','This is Domain A');
1 rows affected

merge into domains A
using 
(select 2 id, 'Domain A' name, 'D.A.' code, 'This is Domain A' description from domains) b
   on ( a.name = b.name )
 when matched then update set a.id = b.id  -- If you wanted to change for the matching case
 when not matched then insert( a.id, a.name, a.code, a.description ) 
                       values( b.id, b.name, b.code, b.description );
                       
1 rows affected

select * from domains;


ID
NAME
CODE
DESCRIPTION


2
Domain A
D.A.
This is Domain A