Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE target_table AS
SELECT 1 as field, 10 as value FROM DUAL UNION ALL
SELECT 2 as field, 12 as value FROM DUAL UNION ALL
SELECT 3 as field, 25 as value FROM DUAL UNION ALL
SELECT 4 as field, 24 as value FROM DUAL;
4 rows affected

CREATE TABLE source_table AS
SELECT 1 as field, 100 as value FROM DUAL UNION ALL
SELECT 2 as field, 120 as value FROM DUAL UNION ALL
SELECT 30 as field, 120 as value FROM DUAL UNION ALL
SELECT 40 as field, 250 as value FROM DUAL UNION ALL
SELECT 50 as field, 240 as value FROM DUAL;
5 rows affected

merge into target_table t
using source_table s
on (s.field = t.field)
when matched then 
    update set t.value = s.value
when not matched then 
    insert (t.field, t.value) values (s.field, s.value)
where t.field = 2 and s.field = 2
ORA-38102: Invalid column in the INSERT WHERE Clause: "T"."FIELD"

select * from target_table


FIELD
VALUE


1
10

2
12

3
25

4
24