1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| MERGE INTO employes TARGET
USING tmp_infooracle SOURCE
ON (TARGET.ID_EMP = SOURCE.ID_EMP)
WHEN MATCHED AND TARGET.NOM_EMP <> SOURCE.NOM_EMP
OR TARGET.PRENOM_EMP <> SOURCE.PRENOM_EMP
OR TARGET.TEL_FIX <> SOURCE.TEL_FIX
OR TARGET.TEL_PORTABLE <> SOURCE.TEL_PORTABLE
OR TARGET.EMAIL <> SOURCE.EMAIL
OR TARGET.CODE_JOB <> SOURCE.CODE_JOB
OR TARGET.POS_CODE <> SOURCE.POS_CODE
UPDATE SET TARGET.NOM_EMP = SOURCE.NOM_EMP,
TARGET.PRENOM_EMP = SOURCE.PRENOM_EMP,
TARGET.TEL_FIX = SOURCE.TEL_FIX,
TARGET.TEL_PORTABLE = SOURCE.TEL_PORTABLE,
TARGET.EMAIL = SOURCE.EMAIL,
TARGET.CODE_JOB = SOURCE.CODE_JOB,
TARGET.POS_CODE = SOURCE.POS_CODE,
WHEN NOT MATCHED BY TARGET THEN
INSERT (ID_EMP, NOM_EMP, PRENOM_EMP, TEL_FIX, TEL_PORTABLE, EMAIL, CODE_JOB, POS_CODE)
VALUES (SOURCE.ID_EMP, SOURCE.NOM_EMP, SOURCE.PRENOM_EMP, SOURCE.TEL_FIX, SOURCE.TEL_PORTABLE, SOURCE.EMAIL, SOURCE.CODE_JOB, SOURCE.POS_CODE)
WHEN NOT MATCHED BY SOURCE THEN
DELETE |
Partager