Oracle 11g Release 2

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

CREATE TABLE TableA (
  Name VARCHAR2(3),
  ID   NUMBER,
  Target_Id NUMBER
);
INSERT INTO TableA ( Name, Id )
  SELECT 'XXX', 13 FROM DUAL UNION ALL
  SELECT 'XXX', 29 FROM DUAL UNION ALL 
  SELECT 'XXX', 31 FROM DUAL UNION ALL
  SELECT 'YYY', 17 FROM DUAL UNION ALL
  SELECT 'YYY', 29 FROM DUAL UNION ALL
  SELECT 'YYY', 38 FROM DUAL;
6 rows affected

MERGE INTO tableA dst
USING tableA src 
ON ( dst.Name = src.Name )
WHEN MATCHED THEN
  UPDATE SET Target_id = src.Id
  WHERE src.id = 29;
6 rows affected

SELECT * FROM tableA


NAME
ID
TARGET_ID


XXX
13
29

XXX
29
29

XXX
31
29

YYY
17
29

YYY
29
29

YYY
38
29