INSERT INTO Client (client_id, nom, adresse) VALUES (9, 'Mittal Steel Company', '4, Regency Square - BRIGHTON UK');

INSERT INTO Delai (delai_id, Prop_30j, Prop_60j, Prop_90j) VALUES (97, 0, 0, 1);

--INSERT INTO commande (commande_id, date_commande, date_livraison, client_id, paiement_id, delai_id)
INSERT INTO commande VALUES (97, to_date('01/01/2009','DD/MM/YYYY'), to_date('10/01/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (97, 1, 15);



INSERT INTO commande VALUES (98, to_date('01/02/2009','DD/MM/YYYY'), to_date('10/02/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (98, 1, 15);



INSERT INTO commande VALUES (99, to_date('01/03/2009','DD/MM/YYYY'), to_date('15/03/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (99, 1, 15);



INSERT INTO commande VALUES (100, to_date('01/04/2009','DD/MM/YYYY'), to_date('13/04/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (100, 1, 15);



INSERT INTO commande VALUES (101, to_date('01/05/2009','DD/MM/YYYY'), to_date('12/05/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (101, 1, 15);



INSERT INTO commande VALUES (102, to_date('01/06/2009','DD/MM/YYYY'), to_date('10/06/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (102, 1, 15);



INSERT INTO commande VALUES (103, to_date('01/07/2009','DD/MM/YYYY'), to_date('10/07/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (103, 1, 15);



INSERT INTO commande VALUES (106, to_date('01/10/2009','DD/MM/YYYY'), to_date('11/10/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (106, 1, 15);



INSERT INTO commande VALUES (107, to_date('01/11/2009','DD/MM/YYYY'), to_date('20/11/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (107, 1, 15);



INSERT INTO commande VALUES (108, to_date('01/12/2009','DD/MM/YYYY'), to_date('14/12/2009','DD/MM/YYYY'), 9, 3, 97);
INSERT INTO Contient VALUES (108, 1, 15);




