Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How does Oracle handle this MERGE use case.

User_0JAQ3Jan 28 2021

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

Comments
Post Details
Added on Jan 28 2021
6 comments
3,449 views