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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73
|
DROP TABLE Poste;
CREATE TABLE POSTE
(
Id NUMBER(3) PRIMARY KEY,
nom VARCHAR2(35),
dateDebut DATE,
DateFin DATE
);
DROP TABLE situation;
CREATE TABLE SITUATION
(
Id NUMBER(3) PRIMARY KEY,
dateDebutSit DATE,
DateFinSit DATE,
idPoste NUMBER
);
INSERT
INTO POSTE VALUES
(
1 ,
'POSTE1' ,
to_date('01/01/2014','DD/MM/YYYY'),
to_date('31/12/2014','DD/MM/YYYY')
);
INSERT
INTO POSTE VALUES
(
2 ,
'POSTE2' ,
to_date('01/01/2013','DD/MM/YYYY'),
to_date('31/12/2014','DD/MM/YYYY')
);
INSERT
INTO SITUATION
(SELECT 1,
to_date('01/02/2014','DD/MM/YYYY'),
to_date('28/02/2014','DD/MM/YYYY'),
1
FROM dual
UNION
SELECT 2,
to_date('20/02/2014','DD/MM/YYYY'),
to_date('20/03/2014','DD/MM/YYYY'),
1
FROM dual
UNION
SELECT 3,
to_date('01/06/2014','DD/MM/YYYY'),
to_date('30/06/2014','DD/MM/YYYY'),
1
FROM dual
);
INSERT
INTO SITUATION
(SELECT 12,
to_date('01/02/2013','DD/MM/YYYY'),
to_date('28/07/2013','DD/MM/YYYY'),
2
FROM dual
UNION
SELECT 22,
to_date('20/11/2013','DD/MM/YYYY'),
to_date('11/03/2014','DD/MM/YYYY'),
2
FROM dual
UNION
SELECT 32,
to_date('17/06/2014','DD/MM/YYYY'),
to_date('30/07/2014','DD/MM/YYYY'),
2
FROM dual
); |
Partager