HOW TO USE RETURNING CLAUSE USING MERGE
614443Dec 20 2007 — edited Jan 3 2008Hello All,
Is there a way to find out the rows that got inserted into a table using the merge statement.
Merge statement is given below. I need to know what rows were inserted when this query got executed.
MERGE INTO PR P USING
(
(SELECT A.ID, A.NAME, A.PENSION FROM MEMBER_PROFILE A, PROFILE B WHERE A.ID=B.ID)RES
ON P.PENSION = RES.PENSION
)
WHEN MATCHED THEN
UPDATE SET P.MOD_DATE= SYSDATE
WHEN NOT MATCHED THEN
INSERT(P.ID, P.NAME, P.PENSION)
VALUES(RES.ID, RES.NAME, RES.PENSION)