1 2 3 4
| INSERT INTO INTERVENTION
(CD_INTERVENTION,ID_INTERVENTION,NB_IMPLIQUES,DATE_INTERVENTION,DATE_DECLENCHEMENT,DATE_SAISIE_18,DATE_ARRIVEE_LIEUX,DATE_DEPART_LIEUX,DATE_DEPART_CIS,DATE_ARRIVEE_CIS,ASTREINTE,ANNULATION,ID_MOTIF_DEPART,ID_CIS,ID_TYPE_INTERVENTION,ID_CIRCONSTANCE,NO_INSEE_COMMUNE,ID_INFIRMIER,TS_INTERVENTION)
VALUES
( SEQ_INTERVENTION.nextval, '101', '1', '22/04/2008', TO_DATE(TO_CHAR(SYSDATE, 'DDMMYYYY') || '1606', 'DDMMYYYYHH24MI') , TO_DATE(TO_CHAR(SYSDATE, 'DDMMYYYY') || '1605', 'DDMMYYYYHH24MI') , TO_DATE(TO_CHAR(SYSDATE, 'DDMMYYYY') || '1608', 'DDMMYYYYHH24MI') , TO_DATE(TO_CHAR(SYSDATE, 'DDMMYYYY') || '1609', 'DDMMYYYYHH24MI') , TO_DATE(TO_CHAR(SYSDATE, 'DDMMYYYY') || '1607', 'DDMMYYYYHH24MI') , TO_DATE(TO_CHAR(SYSDATE, 'DDMMYYYY') || '1610', 'DDMMYYYYHH24MI') , 'O', 'N', '1', '100052', '1', '', '44007', '3', SYSDATE) |
Partager