1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| MERGE INTO IO_CDE_MAG c
USING ds_cde_mag_0011_merge s
ON (c.NUM_PLAN_DOSS=s.NUM_PLAN_DOSS and c.CODE_MAG=s.CODE_MAG)
WHEN MATCHED THEN
update set DATMOD='20080626'
delete where (NUM_PLAN_DOSS='100059' )
WHEN NOT MATCHED THEN
INSERT (
NUM_PLAN_DOSS,
CODE_MAG,
CODSOC,
NUM_CDE_MAG ,
DATE_INTEG_CDE,
HEU_INTEG_CDE,
NB_LIG_ENT_RCUE,
NB_LIG_ENT_AINTEG ,
NB_LIG_ENT_ACC,
QTE_UV_ENT_RCUE ,
QTE_UV_ENT_AINTEG ,
QTE_UV_ENT_ACC,
AREC ,
DATMOD,
UTIMOD )
VALUES ( s.NUM_PLAN_DOSS,
s.CODE_MAG,
s.CODSOC,
s.NUM_CDE_MAG ,
s.DATE_INTEG_CDE,
s.HEU_INTEG_CDE,
s.NB_LIG_ENT_RCUE,
s.NB_LIG_ENT_AINTEG ,
s.NB_LIG_ENT_ACC,
s.QTE_UV_ENT_RCUE ,
s.QTE_UV_ENT_AINTEG ,
s.QTE_UV_ENT_ACC,
s.AREC ,
s.DATMOD,
s.UTIMOD ); |
Partager