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!
When not matched then delete from target not working. Please suggest.
MERGE INTO pppp pp
USING pppp1 p1
ON (pp.productnr = p1.productnr)
WHEN NOT MATCHED
THEN
DELETE