Drop table PRODUIT;
Drop table VENTE;
Drop table ACHAT;
Create table PRODUIT(NPRO integer primary key, NOMP char(10), 
						QTS integer, COULEUR char(10));
Create table VENTE(NVEN integer primary key, NOMC char(10),
						NPRV integer, QTV integer, DATEV date);
Create table ACHAT(NACH integer primary key, NOMF char(10), 
						NPRA integer, QTA integer, DATEA date);

Insert into PRODUIT values (1, 'savon',10,'blanc');
Insert into PRODUIT values (2, 'savon',2,'rose');
Insert into PRODUIT values (3, 'savon',7,'vert');
Insert into PRODUIT values (4, 'savon',15,'violet');
Insert into PRODUIT values (5, 'savon',6,'marron');

Insert into PRODUIT values (6, 'shampoing',1,'blanc');
Insert into PRODUIT values (7, 'shampoing',20,'vert');
Insert into PRODUIT values (8, 'shampoing',5,'bleu');
Insert into PRODUIT values (9, 'shampoing',10,'rose');
Insert into PRODUIT values (10, 'shampoing',7,'jaune');

Insert into PRODUIT values (11, 'lessive',25,'blanc');
Insert into PRODUIT values (12, 'lessive',34,'noire');
Insert into PRODUIT values (13, 'lessive',31,'bleu');

Insert into PRODUIT values (14, 'serviette',100,'rouge');
Insert into PRODUIT values (15, 'serviette',22,'jaune');
Insert into PRODUIT values (16, 'serviette',35,'bleu');
Insert into PRODUIT values (17, 'serviette',41,'beige');
Insert into PRODUIT values (18, 'serviette',58,'vert');
Insert into PRODUIT values (19, 'serviette',64,'violet');
Insert into PRODUIT values (20, 'serviette',82,'cyan');

Insert into PRODUIT values (21, 'torchon',10,'rouge');
Insert into PRODUIT values (22, 'torchon',26,'jaune');
Insert into PRODUIT values (23, 'torchon',101,'bleu');
Insert into PRODUIT values (24, 'torchon',12,'beige');
Insert into PRODUIT values (25, 'torchon',82,'cyan');

Insert into PRODUIT values (26, 'crayon',12,'rouge');
Insert into PRODUIT values (27, 'crayon',25,'vert');
Insert into PRODUIT values (28, 'crayon',150,'bleu');
Insert into PRODUIT values (29, 'crayon',36,'violet');
Insert into PRODUIT values (30, 'crayon',27,'bordeau');
Insert into PRODUIT values (31, 'crayon',16,'magenta');

Insert into PRODUIT values (32, 'ciseaux',14,'orange');
Insert into PRODUIT values (33, 'ciseaux',16,'jaune');
Insert into PRODUIT values (34, 'ciseaux',10,'rose');
Insert into PRODUIT values (35, 'ciseaux',9,'rose');

Insert into PRODUIT values (36, 'verre',10,'bleu');
Insert into PRODUIT values (37, 'verre',18,'rose');
Insert into PRODUIT values (38, 'verre',156,'vert');
Insert into PRODUIT values (39, 'verre',36,'violet');
Insert into PRODUIT values (40, 'verre',78,'orange');

Insert into PRODUIT values (41, 'tasse',15,'bleu');
Insert into PRODUIT values (42, 'tasse',160,'beige');
Insert into PRODUIT values (43, 'tasse',35,'violet');

Insert into PRODUIT values (44, 'mouchoir',120,'bleu');
Insert into PRODUIT values (45, 'mouchoir',64,'rose');
Insert into PRODUIT values (46, 'mouchoir',136,'violet');

Insert into PRODUIT values (47, 'cahier',25,'bleu');
Insert into PRODUIT values (48, 'cahier',76,'beige');
Insert into PRODUIT values (49, 'cahier',153,'violet');
Insert into PRODUIT values (50, 'cahier',81,'orange');

Insert into VENTE values (1,'dupont',1,10,'10-FEB-84');
Insert into VENTE values (2,'dupont',6,11,'11-MAY-01');
Insert into VENTE values (3,'dupont',45,25,'23-JUN-86');
Insert into VENTE values (4,'dupont',26,36,'12-MAR-01');
Insert into VENTE values (5,'dupont',14,12,'30-JAN-82');
Insert into VENTE values (6,'dupont',38,78,'20-NOV-83');
Insert into VENTE values (7,'dupont',12,21,'03-DEC-97');

Insert into VENTE values (8,'durant',1,12,'01-JAN-92');
Insert into VENTE values (9,'durant',26,13,'09-FEB-93');
Insert into VENTE values (10,'durant',38,15,'15-MAR-94');
Insert into VENTE values (11,'durant',39,18,'18-DEC-98');
Insert into VENTE values (12,'durant',50,2,'19-JUN-90');
Insert into VENTE values (13,'durant',39,1,'25-SEP-87');
Insert into VENTE values (14,'durant',27,3,'31-OCT-86');
Insert into VENTE values (15,'durant',28,4,'30-NOV-84');
Insert into VENTE values (16,'durant',32,9,'27-DEC-85');
Insert into VENTE values (17,'durant',35,17,'12-JAN-86');
Insert into VENTE values (18,'durant',11,15,'16-MAY-98');
Insert into VENTE values (19,'durant',2,16,'05-OCT-99');
Insert into VENTE values (20,'durant',6,4,'04-DEC-02');

Insert into VENTE values (21,'duschmoll',1,1,'23-JUN-02');
Insert into VENTE values (22,'duschmoll',2,2,'25-SEP-01');
Insert into VENTE values (23,'duschmoll',3,5,'25-JUN-00');
Insert into VENTE values (24,'duschmoll',4,12,'23-OCT-99');
Insert into VENTE values (25,'duschmoll',45,16,'17-NOV-98');
Insert into VENTE values (26,'duschmoll',43,78,'16-SEP-97');
Insert into VENTE values (27,'duschmoll',12,2,'29-OCT-96');
Insert into VENTE values (28,'duschmoll',39,16,'28-NOV-94');
Insert into VENTE values (29,'duschmoll',34,19,'28-FEB-93');
Insert into VENTE values (30,'duschmoll',46,23,'12-OCT-92');
Insert into VENTE values (31,'duschmoll',8,56,'08-SEP-91');
Insert into VENTE values (32,'duschmoll',12,47,'07-NOV-90');
Insert into VENTE values (33,'duschmoll',16,46,'06-JUN-89');
Insert into VENTE values (34,'duschmoll',9,35,'31-JAN-88');
Insert into VENTE values (35,'duschmoll',6,92,'11-FEB-87');
Insert into VENTE values (36,'duschmoll',1,12,'12-OCT-86');
Insert into VENTE values (37,'duschmoll',2,13,'16-NOV-85');
Insert into VENTE values (38,'duschmoll',5,2,'17-MAY-91');
Insert into VENTE values (39,'duschmoll',4,2,'19-OCT-91');
Insert into VENTE values (40,'duschmoll',1,1,'20-FEB-92');

Insert into VENTE values (41,'pasqual',15,21,'10-MAY-86');
Insert into VENTE values (42,'pasqual',16,31,'16-SEP-85');
Insert into VENTE values (43,'pasqual',17,34,'18-FEB-86');
Insert into VENTE values (44,'pasqual',20,1,'19-MAY-84');
Insert into VENTE values (45,'pasqual',32,10,'26-DEC-80');
Insert into VENTE values (46,'pasqual',36,7,'25-SEP-82');
Insert into VENTE values (47,'pasqual',37,9,'30-OCT-83');
Insert into VENTE values (48,'pasqual',9,8,'25-NOV-84');

Insert into VENTE values (49,'martin',24,8,'10-FEB-82');
Insert into VENTE values (50,'martin',29,7,'31-JAN-83');
Insert into VENTE values (51,'martin',28,6,'10-NOV-84');
Insert into VENTE values (52,'martin',32,26,'12-OCT-85');
Insert into VENTE values (53,'martin',39,27,'15-DEC-82');
Insert into VENTE values (54,'martin',29,36,'16-JUN-84');
Insert into VENTE values (55,'martin',49,46,'17-MAY-86');

Insert into VENTE values (56,'benatar',28,1,'10-FEB-83');
Insert into VENTE values (57,'benatar',8,36,'11-JAN-82');
Insert into VENTE values (58,'benatar',12,25,'11-MAY-86');
Insert into VENTE values (59,'benatar',12,12,'26-JUN-85');
Insert into VENTE values (60,'benatar',36,3,'27-DEC-81');

Insert into VENTE values (61,'satriani',25,1,'11-JAN-81');
Insert into VENTE values (62,'satriani',8,10,'15-DEC-83');
Insert into VENTE values (63,'satriani',2,10,'20-JAN-93');
Insert into VENTE values (64,'satriani',35,8,'26-DEC-97');
Insert into VENTE values (65,'satriani',22,9,'28-JUN-98');
Insert into VENTE values (66,'satriani',21,13,'30-MAY-01');
Insert into VENTE values (67,'satriani',50,15,'30-JUN-02');
Insert into VENTE values (68,'satriani',49,14,'24-MAY-91');
Insert into VENTE values (69,'satriani',6,17,'16-JAN-96');
Insert into VENTE values (70,'satriani',13,10,'17-JUN-95');
Insert into VENTE values (71,'satriani',19,10,'18-FEB-96');
Insert into VENTE values (72,'satriani',20,9,'10-OCT-97');

Insert into VENTE values (73,'jordan',12,1,'11-JAN-02');
Insert into VENTE values (74,'jordan',11,23,'15-FEB-01');
Insert into VENTE values (75,'jordan',12,5,'18-MAY-99');
Insert into VENTE values (76,'jordan',15,2,'19-NOV-97');
Insert into VENTE values (77,'jordan',45,23,'26-OCT-96');
Insert into VENTE values (78,'jordan',32,24,'10-DEC-98');
Insert into VENTE values (79,'jordan',12,14,'26-JUN-99');
Insert into VENTE values (80,'jordan',1,1,'10-JAN-00');
Insert into VENTE values (81,'jordan',4,8,'18-MAY-01');

Insert into VENTE values (82,'oldfield',11,11,'12-JUN-91');
Insert into VENTE values (83,'oldfield',41,12,'21-FEB-92');
Insert into VENTE values (84,'oldfield',21,1,'12-FEB-93');
Insert into VENTE values (85,'oldfield',1,12,'12-NOV-94');
Insert into VENTE values (86,'oldfield',12,12,'25-OCT-95');
Insert into VENTE values (87,'oldfield',3,36,'15-DEC-96');
Insert into VENTE values (88,'oldfield',5,21,'21-JAN-97');
Insert into VENTE values (89,'oldfield',5,65,'01-SEP-98');
Insert into VENTE values (90,'oldfield',5,12,'06-DEC-99');
Insert into VENTE values (91,'oldfield',1,12,'04-OCT-00');
Insert into VENTE values (92,'oldfield',12,1,'16-SEP-01');
Insert into VENTE values (93,'oldfield',4,12,'30-MAY-02');
Insert into VENTE values (94,'oldfield',12,45,'12-JAN-96');
Insert into VENTE values (95,'oldfield',15,65,'15-OCT-97');
Insert into VENTE values (96,'oldfield',26,12,'19-DEC-98');
Insert into VENTE values (97,'oldfield',21,54,'24-SEP-98');
Insert into VENTE values (98,'oldfield',15,1,'30-OCT-99');
Insert into VENTE values (99,'oldfield',12,21,'11-NOV-00');
Insert into VENTE values (100,'oldfield',25,24,'10-FEB-95');

Insert into VENTE values (101,'plisson',1,12,'10-JUN-02');
Insert into VENTE values (102,'plisson',12,12,'12-DEC-02');
Insert into VENTE values (103,'plisson',50,1,'15-MAY-99');
Insert into VENTE values (104,'plisson',50,2,'17-DEC-00');
Insert into VENTE values (105,'plisson',12,4,'19-SEP-01');
Insert into VENTE values (106,'plisson',36,5,'13-JAN-98');
Insert into VENTE values (107,'plisson',1,6,'14-FEB-00');
Insert into VENTE values (108,'plisson',2,4,'15-MAY-01');
Insert into VENTE values (109,'plisson',6,5,'16-JUN-02');
Insert into VENTE values (110,'plisson',78,4,'18-OCT-99');

Insert into VENTE values (111,'pichon',1,12,'11-FEB-02');
Insert into VENTE values (112,'pichon',2,3,'12-OCT-02');
Insert into VENTE values (113,'pichon',3,6,'14-JUN-02');
Insert into VENTE values (114,'pichon',4,7,'14-SEP-02');
Insert into VENTE values (115,'pichon',5,25,'15-JUN-02');
Insert into VENTE values (116,'pichon',6,36,'13-JAN-02');
Insert into VENTE values (117,'pichon',7,25,'12-MAY-02');
Insert into VENTE values (118,'pichon',8,14,'20-DEC-01');
Insert into VENTE values (119,'pichon',9,46,'20-DEC-01');
Insert into VENTE values (120,'pichon',10,12,'13-FEB-01');
Insert into VENTE values (121,'pichon',11,14,'03-JUN-01');
Insert into VENTE values (122,'pichon',12,16,'02-JAN-01');
Insert into VENTE values (123,'pichon',13,26,'04-OCT-99');
Insert into VENTE values (124,'pichon',14,87,'04-JUN-99');
Insert into VENTE values (125,'pichon',15,23,'12-DEC-98');
Insert into VENTE values (126,'pichon',16,95,'10-NOV-98');
Insert into VENTE values (127,'pichon',17,1,'22-JUN-98');
Insert into VENTE values (128,'pichon',18,8,'30-OCT-98');
Insert into VENTE values (129,'pichon',19,9,'12-DEC-98');
Insert into VENTE values (130,'pichon',20,12,'12-MAY-97');
Insert into VENTE values (131,'pichon',21,5,'05-OCT-97');
Insert into VENTE values (132,'pichon',22,25,'12-JUN-97');
Insert into VENTE values (133,'pichon',23,23,'31-MAY-97');
Insert into VENTE values (134,'pichon',24,21,'12-JAN-96');
Insert into VENTE values (135,'pichon',25,15,'12-OCT-96');
Insert into VENTE values (136,'pichon',26,4,'16-NOV-96');
Insert into VENTE values (137,'pichon',27,12,'19-SEP-95');
Insert into VENTE values (138,'pichon',28,1,'26-NOV-94');
Insert into VENTE values (139,'pichon',29,12,'27-FEB-93');
Insert into VENTE values (140,'pichon',30,21,'10-JUN-93');
Insert into VENTE values (141,'pichon',31,1,'28-FEB-93');
Insert into VENTE values (142,'pichon',32,8,'30-JUN-92');
Insert into VENTE values (143,'pichon',33,2,'12-FEB-92');
Insert into VENTE values (144,'pichon',34,45,'15-FEB-92');
Insert into VENTE values (145,'pichon',35,12,'05-NOV-92');
Insert into VENTE values (146,'pichon',36,32,'04-OCT-92');
Insert into VENTE values (147,'pichon',37,45,'10-FEB-91');
Insert into VENTE values (148,'pichon',38,6,'21-MAY-91');
Insert into VENTE values (149,'pichon',39,4,'12-JAN-91');
Insert into VENTE values (150,'pichon',40,4,'22-OCT-91');
Insert into VENTE values (151,'pichon',41,4,'30-JUN-91');
Insert into VENTE values (152,'pichon',42,6,'14-FEB-91');
Insert into VENTE values (153,'pichon',43,2,'16-DEC-91');
Insert into VENTE values (154,'pichon',44,1,'17-FEB-91');
Insert into VENTE values (155,'pichon',45,1,'18-DEC-90');
Insert into VENTE values (156,'pichon',46,5,'19-MAY-90');
Insert into VENTE values (157,'pichon',47,81,'21-JAN-90');
Insert into VENTE values (158,'pichon',48,21,'23-JUN-90');
Insert into VENTE values (159,'pichon',49,81,'24-NOV-90');
Insert into VENTE values (160,'pichon',50,54,'26-FEB-89');

Insert into VENTE values (161,'poutou',1,12,'12-OCT-91');
Insert into VENTE values (162,'poutou',2,15,'15-NOV-91');
Insert into VENTE values (163,'poutou',3,45,'16-DEC-99');
Insert into VENTE values (164,'poutou',4,52,'17-JAN-96');
Insert into VENTE values (165,'poutou',5,45,'18-OCT-01');
Insert into VENTE values (167,'poutou',6,67,'19-MAY-96');
Insert into VENTE values (168,'poutou',7,68,'20-NOV-84');
Insert into VENTE values (169,'poutou',8,61,'23-JUN-96');
Insert into VENTE values (170,'poutou',9,28,'24-FEB-94');
Insert into VENTE values (171,'poutou',10,7,'29-SEP-82');
Insert into VENTE values (172,'poutou',11,1,'30-SEP-01');
Insert into VENTE values (173,'poutou',12,12,'12-JUN-96');
Insert into VENTE values (174,'poutou',13,13,'28-FEB-91');
Insert into VENTE values (175,'poutou',14,18,'12-DEC-96');
Insert into VENTE values (176,'poutou',15,81,'05-JUN-98');
Insert into VENTE values (177,'poutou',16,36,'06-MAY-94');
Insert into VENTE values (178,'poutou',17,47,'08-NOV-89');
Insert into VENTE values (179,'poutou',18,41,'22-NOV-98');
Insert into VENTE values (180,'poutou',19,67,'23-JUN-96');
Insert into VENTE values (181,'poutou',20,98,'19-DEC-91');
Insert into VENTE values (182,'poutou',21,21,'27-FEB-88');
Insert into VENTE values (183,'poutou',22,36,'29-MAY-83');
Insert into VENTE values (184,'poutou',23,39,'30-OCT-91');
Insert into VENTE values (185,'poutou',24,12,'30-JUN-98');
Insert into VENTE values (186,'poutou',25,1,'27-FEB-91');
Insert into VENTE values (187,'poutou',26,1,'26-JAN-96');
Insert into VENTE values (188,'poutou',27,5,'29-NOV-00');
Insert into VENTE values (189,'poutou',28,6,'12-FEB-91');
Insert into VENTE values (190,'poutou',29,7,'13-DEC-95');
Insert into VENTE values (191,'poutou',30,8,'10-SEP-97');
Insert into VENTE values (192,'poutou',31,9,'11-OCT-85');
Insert into VENTE values (193,'poutou',32,10,'16-NOV-00');
Insert into VENTE values (194,'poutou',33,16,'14-DEC-87');
Insert into VENTE values (195,'poutou',34,18,'12-MAY-02');
Insert into VENTE values (196,'poutou',35,14,'13-JUN-91');
Insert into VENTE values (197,'poutou',36,15,'16-JAN-90');
Insert into VENTE values (198,'poutou',37,16,'18-NOV-95');
Insert into VENTE values (199,'poutou',38,20,'19-OCT-97');
Insert into VENTE values (200,'poutou',39,22,'20-JUN-86');
Insert into VENTE values (201,'poutou',40,23,'22-DEC-95');
Insert into VENTE values (202,'poutou',41,14,'13-NOV-01');
Insert into VENTE values (203,'poutou',42,16,'14-JAN-96');
Insert into VENTE values (204,'poutou',43,18,'15-OCT-00');
Insert into VENTE values (205,'poutou',44,7,'26-MAY-93');
Insert into VENTE values (206,'poutou',45,8,'25-NOV-96');
Insert into VENTE values (207,'poutou',46,9,'12-OCT-91');
Insert into VENTE values (208,'poutou',47,5,'13-JUN-95');
Insert into VENTE values (209,'poutou',48,6,'14-OCT-01');
Insert into VENTE values (210,'poutou',49,7,'14-DEC-92');
Insert into VENTE values (211,'poutou',50,12,'15-JUN-02');

Insert into VENTE values (213,'tellier',12,12,'10-FEB-00');
Insert into VENTE values (214,'tellier',12,15,'12-NOV-02');
Insert into VENTE values (215,'tellier',15,18,'16-JAN-87');
Insert into VENTE values (216,'tellier',36,100,'17-JUN-91');
Insert into VENTE values (217,'tellier',37,15,'19-JAN-92');
Insert into VENTE values (218,'tellier',49,18,'23-DEC-02');
Insert into VENTE values (219,'tellier',32,1,'24-JUN-99');

Insert into VENTE values (220,'thureau',31,23,'25-MAY-81');
Insert into VENTE values (221,'thureau',34,21,'28-NOV-83');
Insert into VENTE values (222,'thureau',29,12,'29-JUN-86');

Insert into VENTE values (223,'thielan',28,36,'30-DEC-95');
Insert into VENTE values (224,'thielan',39,34,'30-JUN-94');
Insert into VENTE values (225,'thielan',24,14,'17-OCT-90');
Insert into VENTE values (226,'thielan',15,8,'14-JAN-89');
Insert into VENTE values (227,'thielan',15,8,'16-MAY-86');
Insert into VENTE values (228,'thielan',38,8,'19-SEP-87');
Insert into VENTE values (229,'thielan',3,41,'20-JUN-86');
Insert into VENTE values (230,'thielan',1,120,'29-MAY-94');
Insert into VENTE values (231,'thielan',4,82,'10-NOV-99');
Insert into VENTE values (232,'thielan',6,41,'28-JUN-00');
Insert into VENTE values (233,'thielan',7,10,'20-DEC-01');
Insert into VENTE values (234,'thielan',19,5,'22-FEB-00');

Insert into VENTE values (235,'tarel',12,14,'21-JAN-01');
Insert into VENTE values (236,'tarel',50,74,'29-JUN-01');
Insert into VENTE values (237,'tarel',23,45,'03-SEP-01');
Insert into VENTE values (238,'tarel',45,14,'04-SEP-02');
Insert into VENTE values (239,'tarel',45,16,'09-JUN-99');
Insert into VENTE values (240,'tarel',41,12,'08-NOV-99');
Insert into VENTE values (241,'tarel',16,1,'16-OCT-98');
Insert into VENTE values (242,'tarel',32,8,'14-JUN-97');
Insert into VENTE values (243,'tarel',45,6,'15-SEP-95');
Insert into VENTE values (244,'tarel',62,3,'19-NOV-96');
Insert into VENTE values (245,'tarel',39,15,'20-OCT-99');
Insert into VENTE values (246,'tarel',37,45,'15-DEC-91');
Insert into VENTE values (247,'tarel',28,2,'18-OCT-93');
Insert into VENTE values (248,'tarel',19,14,'19-NOV-94');
Insert into VENTE values (249,'tarel',12,6,'20-DEC-94');
Insert into VENTE values (250,'tarel',13,8,'19-SEP-97');

Insert into ACHAT values (1,'tang',12,12,'11-SEP-81');
Insert into ACHAT values (2,'tang',15,10,'12-OCT-80');
Insert into ACHAT values (3,'tang',15,2,'12-NOV-82');
Insert into ACHAT values (4,'tang',1,32,'15-DEC-82');
Insert into ACHAT values (5,'tang',1,2,'25-FEB-83');
Insert into ACHAT values (6,'tang',50,12,'18-JAN-84');
Insert into ACHAT values (7,'tang',49,2,'19-FEB-85');
Insert into ACHAT values (8,'tang',48,6,'13-JUN-86');
Insert into ACHAT values (9,'tang',47,102,'16-NOV-84');
Insert into ACHAT values (10,'tang',26,12,'29-SEP-83');
Insert into ACHAT values (11,'tang',28,25,'27-JUN-81');
Insert into ACHAT values (12,'tang',23,32,'12-DEC-80');
Insert into ACHAT values (13,'tang',19,12,'28-FEB-82');
Insert into ACHAT values (14,'tang',9,54,'14-DEC-83');

Insert into ACHAT values (15,'temanni',12,12,'13-SEP-81');
Insert into ACHAT values (16,'temanni',15,63,'15-FEB-80');
Insert into ACHAT values (17,'temanni',40,15,'16-NOV-81');
Insert into ACHAT values (18,'temanni',41,16,'19-JAN-86');
Insert into ACHAT values (19,'temanni',12,4,'20-SEP-83');
Insert into ACHAT values (20,'temanni',42,5,'23-MAY-84');
Insert into ACHAT values (21,'temanni',43,62,'24-JUN-85');
Insert into ACHAT values (22,'temanni',46,32,'15-FEB-86');

Insert into ACHAT values (23,'fernand',1,15,'11-NOV-81');
Insert into ACHAT values (24,'fernand',2,16,'10-SEP-82');
Insert into ACHAT values (25,'fernand',3,1,'30-DEC-83');
Insert into ACHAT values (26,'fernand',4,8,'12-NOV-84');
Insert into ACHAT values (27,'fernand',5,9,'11-FEB-85');
Insert into ACHAT values (28,'fernand',6,156,'15-MAY-86');
Insert into ACHAT values (29,'fernand',7,13,'16-JAN-87');
Insert into ACHAT values (30,'fernand',8,160,'18-SEP-88');
Insert into ACHAT values (31,'fernand',9,12,'19-NOV-89');
Insert into ACHAT values (32,'fernand',10,62,'20-OCT-90');
Insert into ACHAT values (33,'fernand',11,8,'23-DEC-91');
Insert into ACHAT values (34,'fernand',12,9,'24-MAY-92');
Insert into ACHAT values (35,'fernand',13,10,'26-SEP-93');
Insert into ACHAT values (36,'fernand',14,13,'28-JUN-94');
Insert into ACHAT values (37,'fernand',15,18,'12-OCT-95');
Insert into ACHAT values (38,'fernand',16,16,'16-NOV-96');
Insert into ACHAT values (39,'fernand',17,13,'18-FEB-97');
Insert into ACHAT values (40,'fernand',18,32,'19-NOV-98');
Insert into ACHAT values (41,'fernand',19,31,'23-OCT-99');
Insert into ACHAT values (42,'fernand',20,31,'26-JUN-00');
Insert into ACHAT values (43,'fernand',21,25,'25-SEP-01');
Insert into ACHAT values (44,'fernand',22,14,'15-JUN-02');
Insert into ACHAT values (45,'fernand',23,26,'08-MAY-83');
Insert into ACHAT values (46,'fernand',24,28,'10-SEP-84');
Insert into ACHAT values (47,'fernand',25,9,'09-FEB-85');
Insert into ACHAT values (48,'fernand',26,7,'06-OCT-86');
Insert into ACHAT values (49,'fernand',27,6,'15-DEC-89');
Insert into ACHAT values (50,'fernand',28,5,'30-NOV-90');
Insert into ACHAT values (51,'fernand',29,4,'25-SEP-91');
Insert into ACHAT values (52,'fernand',30,3,'31-DEC-92');
Insert into ACHAT values (53,'fernand',31,1,'14-NOV-93');
Insert into ACHAT values (54,'fernand',32,15,'16-FEB-94');
Insert into ACHAT values (55,'fernand',33,16,'18-MAY-95');
Insert into ACHAT values (56,'fernand',34,17,'19-JAN-96');
Insert into ACHAT values (57,'fernand',35,19,'20-SEP-97');
Insert into ACHAT values (58,'fernand',36,20,'18-NOV-98');
Insert into ACHAT values (59,'fernand',37,22,'19-OCT-99');
Insert into ACHAT values (60,'fernand',38,23,'13-DEC-00');
Insert into ACHAT values (61,'fernand',39,24,'15-MAY-01');
Insert into ACHAT values (62,'fernand',40,12,'15-SEP-02');
Insert into ACHAT values (63,'fernand',41,8,'06-JUN-95');
Insert into ACHAT values (64,'fernand',42,7,'05-OCT-97');
Insert into ACHAT values (65,'fernand',43,10,'01-FEB-96');
Insert into ACHAT values (66,'fernand',44,20,'12-NOV-98');
Insert into ACHAT values (67,'fernand',45,30,'16-DEC-96');
Insert into ACHAT values (68,'fernand',46,23,'17-NOV-89');
Insert into ACHAT values (69,'fernand',47,25,'18-OCT-92');
Insert into ACHAT values (70,'fernand',48,29,'19-NOV-93');
Insert into ACHAT values (71,'fernand',49,2,'12-SEP-94');
Insert into ACHAT values (72,'fernand',50,1,'13-NOV-02');

Insert into ACHAT values (73,'thureau',12,23,'25-MAY-81');
Insert into ACHAT values (74,'thureau',14,21,'28-NOV-83');
Insert into ACHAT values (75,'thureau',26,12,'29-JUN-86');

Insert into ACHAT values (76,'thielan',1,21,'30-DEC-95');
Insert into ACHAT values (77,'thielan',18,12,'10-NOV-99');
Insert into ACHAT values (78,'thielan',32,15,'28-JUN-00');
Insert into ACHAT values (79,'thielan',31,15,'20-DEC-01');
Insert into ACHAT values (80,'thielan',38,15,'22-FEB-00');

Insert into ACHAT values (81,'tarel',1,14,'21-JAN-01');
Insert into ACHAT values (82,'tarel',2,74,'29-JUN-01');
Insert into ACHAT values (83,'tarel',3,45,'03-SEP-01');
Insert into ACHAT values (84,'tarel',4,14,'04-SEP-02');
Insert into ACHAT values (85,'tarel',5,16,'09-JUN-99');
Insert into ACHAT values (86,'tarel',6,12,'08-NOV-99');
Insert into ACHAT values (87,'tarel',7,1,'16-OCT-98');
Insert into ACHAT values (88,'tarel',8,8,'14-JUN-97');
Insert into ACHAT values (89,'tarel',9,6,'15-SEP-95');
Insert into ACHAT values (90,'tarel',10,3,'19-NOV-96');
Insert into ACHAT values (91,'tarel',11,15,'20-OCT-99');
Insert into ACHAT values (92,'tarel',12,45,'15-DEC-91');
Insert into ACHAT values (93,'tarel',13,2,'18-OCT-93');
Insert into ACHAT values (94,'tarel',14,14,'19-NOV-94');
Insert into ACHAT values (95,'tarel',15,6,'20-DEC-94');
Insert into ACHAT values (96,'tarel',16,8,'19-SEP-97');
Insert into ACHAT values (97,'tarel',17,14,'21-JAN-01');
Insert into ACHAT values (98,'tarel',18,74,'29-JUN-01');
Insert into ACHAT values (99,'tarel',19,45,'03-SEP-01');
Insert into ACHAT values (100,'tarel',20,14,'04-SEP-02');
Insert into ACHAT values (101,'tarel',21,16,'09-JUN-99');
Insert into ACHAT values (102,'tarel',22,12,'08-NOV-99');
Insert into ACHAT values (103,'tarel',23,1,'16-OCT-98');
Insert into ACHAT values (104,'tarel',24,8,'14-JUN-97');
Insert into ACHAT values (105,'tarel',25,6,'15-SEP-95');
Insert into ACHAT values (106,'tarel',26,3,'19-NOV-96');
Insert into ACHAT values (107,'tarel',27,15,'20-OCT-99');
Insert into ACHAT values (108,'tarel',28,45,'15-DEC-91');
Insert into ACHAT values (109,'tarel',29,2,'18-OCT-93');
Insert into ACHAT values (110,'tarel',30,14,'19-NOV-94');
Insert into ACHAT values (111,'tarel',31,6,'20-DEC-94');
Insert into ACHAT values (112,'tarel',32,8,'19-SEP-97');
Insert into ACHAT values (113,'tarel',33,14,'21-JAN-01');
Insert into ACHAT values (114,'tarel',34,74,'29-JUN-01');
Insert into ACHAT values (115,'tarel',35,45,'03-SEP-01');
Insert into ACHAT values (116,'tarel',36,14,'04-SEP-02');
Insert into ACHAT values (117,'tarel',37,16,'09-JUN-99');
Insert into ACHAT values (118,'tarel',38,12,'08-NOV-99');
Insert into ACHAT values (119,'tarel',39,1,'16-OCT-98');
Insert into ACHAT values (120,'tarel',40,8,'14-JUN-97');
Insert into ACHAT values (121,'tarel',41,6,'15-SEP-95');
Insert into ACHAT values (122,'tarel',42,3,'19-NOV-96');
Insert into ACHAT values (123,'tarel',43,15,'20-OCT-99');
Insert into ACHAT values (124,'tarel',44,45,'15-DEC-91');
Insert into ACHAT values (125,'tarel',45,2,'18-OCT-93');
Insert into ACHAT values (126,'tarel',46,14,'19-NOV-94');
Insert into ACHAT values (127,'tarel',47,6,'20-DEC-94');
Insert into ACHAT values (128,'tarel',48,8,'19-SEP-97');
Insert into ACHAT values (129,'tarel',49,8,'19-NOV-97');
Insert into ACHAT values (130,'tarel',50,8,'19-DEC-97');

Insert into ACHAT values (131,'vanderz',1,23,'25-MAY-01');
Insert into ACHAT values (132,'vanderz',2,45,'26-SEP-01');
Insert into ACHAT values (133,'vanderz',3,50,'03-MAY-01');
Insert into ACHAT values (134,'vanderz',4,12,'08-JAN-02');
Insert into ACHAT values (135,'vanderz',5,50,'07-MAY-99');
Insert into ACHAT values (136,'vanderz',6,16,'26-NOV-99');
Insert into ACHAT values (137,'vanderz',7,1,'23-JAN-98');
Insert into ACHAT values (138,'vanderz',8,8,'26-JUN-97');
Insert into ACHAT values (139,'vanderz',9,9,'28-SEP-95');
Insert into ACHAT values (140,'vanderz',10,2,'29-SEP-96');
Insert into ACHAT values (141,'vanderz',11,15,'30-JAN-99');
Insert into ACHAT values (142,'vanderz',12,58,'25-DEC-91');
Insert into ACHAT values (143,'vanderz',13,63,'25-MAY-93');
Insert into ACHAT values (144,'vanderz',14,15,'30-SEP-94');
Insert into ACHAT values (145,'vanderz',15,15,'12-JAN-94');
Insert into ACHAT values (146,'vanderz',16,9,'19-MAY-97');
Insert into ACHAT values (147,'vanderz',17,16,'09-JAN-01');
Insert into ACHAT values (148,'vanderz',18,18,'02-JUN-01');
Insert into ACHAT values (149,'vanderz',19,19,'01-JAN-01');
Insert into ACHAT values (150,'vanderz',20,12,'01-DEC-02');
Insert into ACHAT values (151,'vanderz',21,30,'01-SEP-99');
Insert into ACHAT values (152,'vanderz',22,120,'05-NOV-99');
Insert into ACHAT values (153,'vanderz',23,2,'17-OCT-98');
Insert into ACHAT values (154,'vanderz',24,9,'15-JUN-97');
Insert into ACHAT values (155,'vanderz',25,8,'16-JUN-95');
Insert into ACHAT values (156,'vanderz',26,9,'18-NOV-96');
Insert into ACHAT values (157,'vanderz',27,16,'21-DEC-99');
Insert into ACHAT values (158,'vanderz',28,52,'16-SEP-91');
Insert into ACHAT values (159,'vanderz',29,35,'17-NOV-93');
Insert into ACHAT values (160,'vanderz',30,36,'18-JAN-94');
Insert into ACHAT values (161,'vanderz',31,8,'21-JUN-94');
Insert into ACHAT values (162,'vanderz',32,9,'18-SEP-97');
Insert into ACHAT values (163,'vanderz',33,14,'22-SEP-01');
Insert into ACHAT values (164,'vanderz',34,15,'28-JAN-01');
Insert into ACHAT values (165,'vanderz',35,16,'04-SEP-01');
Insert into ACHAT values (166,'vanderz',36,15,'05-DEC-02');
Insert into ACHAT values (167,'vanderz',37,19,'08-JUN-99');
Insert into ACHAT values (168,'vanderz',38,20,'08-NOV-99');
Insert into ACHAT values (169,'vanderz',39,12,'17-JAN-98');
Insert into ACHAT values (170,'vanderz',40,5,'15-SEP-97');
Insert into ACHAT values (171,'vanderz',41,9,'16-SEP-95');
Insert into ACHAT values (172,'vanderz',42,10,'18-NOV-96');
Insert into ACHAT values (173,'vanderz',43,2,'21-OCT-99');
Insert into ACHAT values (174,'vanderz',44,36,'16-DEC-91');
Insert into ACHAT values (175,'vanderz',45,5,'19-JAN-93');
Insert into ACHAT values (176,'vanderz',46,19,'20-NOV-94');
Insert into ACHAT values (177,'vanderz',47,20,'21-DEC-94');
Insert into ACHAT values (178,'vanderz',48,39,'20-JAN-97');
Insert into ACHAT values (179,'vanderz',49,58,'23-SEP-97');
Insert into ACHAT values (180,'vanderz',50,2,'25-DEC-97');

Insert into ACHAT values (181,'veerse',12,12,'21-DEC-80');
Insert into ACHAT values (182,'veerse',48,1,'01-OCT-82');
Insert into ACHAT values (183,'veerse',47,12,'02-MAY-90');
Insert into ACHAT values (184,'veerse',46,3,'21-NOV-98');
Insert into ACHAT values (185,'veerse',45,4,'19-DEC-99');
Insert into ACHAT values (186,'veerse',44,6,'09-JUN-00');
Insert into ACHAT values (187,'veerse',43,120,'19-OCT-02');
Insert into ACHAT values (188,'veerse',39,12,'21-FEB-89');
Insert into ACHAT values (189,'veerse',38,15,'07-NOV-88');

Insert into ACHAT values (190,'xuong',1,102,'17-JAN-97');
Insert into ACHAT values (191,'xuong',2,12,'15-FEB-98');
Insert into ACHAT values (192,'xuong',3,61,'14-OCT-99');
Insert into ACHAT values (193,'xuong',4,21,'16-MAY-00');
Insert into ACHAT values (194,'xuong',5,15,'19-JUN-01');
Insert into ACHAT values (195,'xuong',30,26,'21-OCT-02');
Insert into ACHAT values (196,'xuong',31,51,'29-JUN-01');
Insert into ACHAT values (197,'xuong',32,1,'30-DEC-99');
Insert into ACHAT values (198,'xuong',33,64,'28-OCT-98');
Insert into ACHAT values (199,'xuong',34,64,'15-DEC-99');
Insert into ACHAT values (200,'xuong',35,12,'12-NOV-02');

Insert into ACHAT values (201,'bertram',21,1,'25-JAN-01');
Insert into ACHAT values (202,'bertram',11,2,'12-DEC-99');
Insert into ACHAT values (203,'bertram',10,3,'19-MAY-95');
Insert into ACHAT values (204,'bertram',12,56,'30-DEC-90');
Insert into ACHAT values (205,'bertram',26,10,'21-OCT-89');
Insert into ACHAT values (206,'bertram',27,30,'22-JUN-85');
Insert into ACHAT values (207,'bertram',12,20,'30-DEC-86');
Insert into ACHAT values (208,'bertram',1,26,'14-JAN-87');
Insert into ACHAT values (209,'bertram',2,28,'29-MAY-96');
Insert into ACHAT values (210,'bertram',2,29,'25-SEP-98');
Insert into ACHAT values (211,'bertram',2,20,'21-OCT-99');
Insert into ACHAT values (212,'bertram',3,14,'26-DEC-00');
Insert into ACHAT values (213,'bertram',4,16,'24-NOV-01');
Insert into ACHAT values (214,'bertram',5,17,'22-MAY-02');
Insert into ACHAT values (215,'bertram',8,19,'20-NOV-99');
Insert into ACHAT values (216,'bertram',8,17,'10-FEB-89');
Insert into ACHAT values (217,'bertram',9,13,'26-DEC-92');
Insert into ACHAT values (218,'bertram',7,14,'22-JAN-95');
Insert into ACHAT values (219,'bertram',6,15,'23-DEC-94');
Insert into ACHAT values (220,'bertram',49,13,'14-JUN-97');

Insert into ACHAT values (221,'blum',13,12,'19-SEP-98');
Insert into ACHAT values (222,'blum',11,1,'21-DEC-99');
Insert into ACHAT values (223,'blum',11,9,'22-NOV-97');
Insert into ACHAT values (224,'blum',29,13,'26-FEB-98');
Insert into ACHAT values (225,'blum',27,125,'27-MAY-99');
Insert into ACHAT values (226,'blum',7,156,'28-DEC-99');
Insert into ACHAT values (227,'blum',5,100,'30-JAN-98');

Insert into ACHAT values (228,'bore',12,112,'12-JUN-97');
Insert into ACHAT values (229,'bore',45,10,'13-FEB-98');
Insert into ACHAT values (230,'bore',44,8,'21-OCT-00');
Insert into ACHAT values (231,'bore',30,9,'19-DEC-01');
Insert into ACHAT values (232,'bore',31,20,'25-MAY-02');
Insert into ACHAT values (233,'bore',32,30,'16-DEC-02');
Insert into ACHAT values (234,'bore',33,40,'17-JUN-01');
Insert into ACHAT values (235,'bore',29,50,'10-DEC-01');
Insert into ACHAT values (236,'bore',28,60,'22-MAY-00');
Insert into ACHAT values (237,'bore',26,7,'21-FEB-98');
Insert into ACHAT values (238,'bore',24,15,'16-DEC-99');
Insert into ACHAT values (239,'bore',22,16,'12-JUN-98');
Insert into ACHAT values (240,'bore',19,17,'01-OCT-99');
Insert into ACHAT values (241,'bore',17,12,'13-SEP-95');
Insert into ACHAT values (242,'bore',15,15,'19-NOV-96');
Insert into ACHAT values (243,'bore',14,12,'28-JAN-97');
Insert into ACHAT values (244,'bore',13,14,'21-FEB-98');
Insert into ACHAT values (245,'bore',11,11,'30-MAY-99');
Insert into ACHAT values (246,'bore',9,16,'14-JUN-00');
Insert into ACHAT values (247,'bore',7,8,'15-NOV-00');
Insert into ACHAT values (248,'bore',6,9,'16-DEC-01');
Insert into ACHAT values (249,'bore',5,10,'17-OCT-92');
Insert into ACHAT values (250,'bore',2,120,'18-SEP-93');
