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