1 2 3 4 5 6 7 8 9 10 11 12
| MERGE INTO T3 c
USING (select TO_NUMBER(a.ID) as ID,a.ID_PERSO,TO_DATE(a.DATEDEBUT,'YYYYMMDD') as DATEDEBUT,TO_DATE(a.DATEFIN,'YYYYMMDD') as DATEFIN,a.DATE_SYS,TO_NUMBER(substr(a.datefin,1,4)) as SAISON from T1 a) d
ON (d.ID=c.ID)
WHEN MATCHED THEN
UPDATE SET c.DATE_DEB=d.DATEDEBUT,
c.DATE_FIN=d.DATEFIN,
c.ID_PERS=d.ID_PERS,
c.DATE_SYS=d.DATE_SYS,
c.SAISON=d.SAISON
WHEN NOT MATCHED THEN
INSERT (c.ID_PASS,c.DATE_DEB,c.DATE_FIN,c.ID_PERS,c.DATE_SYS,c.SAISON)
VALUES (d.ID,d.DATEDEBUT,d.DATEFIN,d.ID_PERS,d.DATE_SYS,d.SAISON) ; |
Partager