1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| MERGE INTO HMV_SUIV e
USING (SELECT ".$_POST["unite"]." as UNT_NID ,
".$SEC_NID." as SEC_NID ,
".$MNCITEM_NID." as MNCITEM_NID,
".$_POST["mois"]." as TRTMT_MOIS ,
".$_POST["annee"]." as TRTMT_ANNEE,
".$PRLVMT_NNOMBRE." as PRLVMT_NNOMBRE
FROM DUAL) p
ON (e.UNT_NID = p.UNT_NID
AND e.SEC_NID = p.SEC_NID
AND e.MNCITEM_NID = p.MNCITEM_NID
AND e.TRTMT_MOIS = p.TRTMT_MOIS
AND e.TRTMT_ANNEE = p.TRTMT_ANNEE)
WHEN MATCHED THEN UPDATE
SET e.PRLVMT_NNOMBRE = p.PRLVMT_NNOMBRE
WHEN NOT MATCHED THEN
INSERT (e.UNT_NID, e.PRLVMT_NNOMBRE, e.SEC_NID, e.MNCITEM_NID, e.TRTMT_MOIS, e.TRTMT_ANNEE)
VALUES (p.UNT_NID, p.PRLVMT_NNOMBRE, p.SEC_NID, p.MNCITEM_NID, p.TRTMT_MOIS, p.TRTMT_ANNEE); |
Partager