MERGE INTO omitting WHEN NOT MATCHED

[nomula_s]

Can you write a MERGE statement omitting one of the WHEN MATCHED and WHE NOT MACTHED statements. In my program I have to update when macthed and not do any thing when not matched.

EX:

 MERGE INTO table1 tb1 USING table2 tb2 
WHEN MACTHED THEN
UPDATE SET
tb1.col1 = tb2.col1
WHEN NOT MACTHED
 

then do nothing

I tried completely omitting WHEN NOT MACTHED and putting NULL; under WHEN NOT MACTHED section which always gave me sysntax error. I need a solution urgently. Any help is greatly appreciated.

-Sree

[rebeaj]

I can't even get my merge statement to work. I see that you have been successful at it. I don't think that you can leave out the when not matched. Here is my merge statement. I cannot get it to compile without errors:

 CREATE OR REPLACE PROCEDURE P_PVT_MERGE 
AS
BEGIN 
MERGE INTO EMPLOYEES2 B
USING (
SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME, DEPT_NO, SALARY
FROM EMPLOYEES
WHERE DEPT_NO = 20) E
ON (B.EMPLOYEE_ID = E.EMPLOYEE_ID)
WHEN MATCHED THEN
UPDATE SET B.EMPLOYEE_ID = E.EMPLOYEE_ID,
B.FIRST_NAME = E.FIRST_NAME,
B.LAST_NAME = E.LAST_NAME,
B.DEPT_NO = E.DEPT_NO,
B.SALARY = E.SALARY
WHEN NOT MATCHED THEN
INSERT (B.EMPLOYEE_ID, B.FIRST_NAME, B.LAST_NAME, B.DEPT_NO, B.SALARY)
VALUES (E.EMPLOYEE_ID, E.FIRST_NAME, E.LAST_NAME, E.DEPT_NO, E.SALARY)
COMMIT;
END;
 

/