Skip to Main Content

SQL Developer

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!

hi experts can we delete record using merge statement

User_8GUKBMay 26 2022

MERGE INTO emp_2 e2
USING emp_1 e1
ON(e1.emp_id=e2.emp_id)
WHEN MATCHED THEN
UPDATE SET e2.emp_name=e1.emp_name
WHEN NOT MATCHED THEN
INSERT(e2.emp_id,e2.emp_name)VALUES(e1.emp_id,e1.emp_name)
WHEN NOT MATCHED BY e2 THEN
DELETE;

I faced below error
WHEN NOT MATCHED BY e2 THEN
*
ERROR at line 8:
ORA-00905: missing keyword
how i overcome it ,please give a solution

This post has been answered by Solomon Yakobson on May 26 2022
Jump to Answer

Comments

Processing

Post Details

Added on May 26 2022
2 comments
702 views