Below is the exact use case that I need to resolve, but I understand that I can't use the statement below.
WHEN NOT MATCHED BY SOURCE
So how does Oracle handle the issue below in a merge statement?
--When there is a row that exists in target and same record does not exist in source then delete this record target