Hi Gurus,
I am getting an error saying missing keyword in the merge statement.
I am just trying to inactivate target if it is not present on source.
Not sure what am I missing here.
Could you please help?
MERGE INTO target TGT
USING ( SELECT *
FROM source) SRC
ON ( TGT.ID = SRC.ID )
WHEN NOT MATCHED THEN
UPDATE SET TGT.inaative_date = SYSDATE ;