Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --------------------------------------------------------
- -- Fichier créé - mercredi-avril-19-2017
- --------------------------------------------------------
- --------------------------------------------------------
- -- DDL for Table AVION
- --------------------------------------------------------
- CREATE TABLE "TP2"."AVION"
- ( "IMMATRICULATION" NUMBER(*,0),
- "NOM" VARCHAR2(10 BYTE),
- "CONSTRUCTEUR" VARCHAR2(30 BYTE),
- "CAPACITE" NUMBER(*,0),
- "NOMBRE_REACTEURS" NUMBER(*,0),
- "LARGEUR" NUMBER(*,0)
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table PASSAGER
- --------------------------------------------------------
- CREATE TABLE "TP2"."PASSAGER"
- ( "ID" NUMBER(*,0),
- "NOM" VARCHAR2(80 BYTE),
- "PRENOM" VARCHAR2(80 BYTE),
- "POIDS" NUMBER(*,0),
- "VOL" NUMBER(*,0)
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table VILLE
- --------------------------------------------------------
- CREATE TABLE "TP2"."VILLE"
- ( "NOM" VARCHAR2(100 BYTE),
- "CODE_POSTAL" CHAR(10 BYTE)
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "SYSTEM" ;
- --------------------------------------------------------
- -- DDL for Table VOL
- --------------------------------------------------------
- CREATE TABLE "TP2"."VOL"
- ( "ID" NUMBER(*,0),
- "DESIGNATION" VARCHAR2(100 BYTE),
- "VILLE_ORIGINE" CHAR(10 BYTE),
- "VILLE_ARRIVEE" CHAR(10 BYTE),
- "AVION" NUMBER(*,0),
- "DATE_DEPART" DATE,
- "DATE_ARRIVEE" DATE,
- "DUREE" NUMBER(*,0)
- ) SEGMENT CREATION IMMEDIATE
- PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "SYSTEM" ;
- REM INSERTING INTO TP2.AVION
- SET DEFINE OFF;
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('1','nibh.','Dassault','244','6','139');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('2','elit','Boeing','378','5','145');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('3','tempus','Airbus','376','5','99');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('4','varius','Airbus','286','4','86');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('5','Nullam','Dassault','223','4','115');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('6','mi','Dassault','377','8','125');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('7','placerat','Dassault','397','7','147');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('8','dolor','Airbus','223','9','88');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('10','cursus','Airbus','278','8','114');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('11','elit,','Dassault','391','6','120');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('12','dolor','Dassault','224','9','125');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('13','arcu','Dassault','379','6','83');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('14','Aliquam','Airbus','392','8','134');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('15','posuere,','Boeing','341','9','125');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('16','Mauris','Airbus','392','5','105');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('17','sociis','Dassault','369','8','89');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('18','ad','Boeing','254','8','128');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('21','enim','Dassault','318','9','108');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('22','Vivamus','Airbus','209','5','142');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('23','nulla.','Dassault','280','5','126');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('24','molestie','Dassault','216','5','118');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('25','faucibus','Boeing','377','5','139');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('26','eu','Airbus','394','4','124');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('27','mollis','Dassault','316','4','119');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('28','cursus','Boeing','376','10','81');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('29','lectus','Dassault','333','4','100');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('30','aliquet,','Airbus','251','7','133');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('31','hendrerit','Dassault','247','4','122');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('32','purus,','Airbus','255','8','122');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('33','ultrices','Boeing','228','10','123');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('34','Phasellus','Dassault','292','4','95');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('35','magna','Airbus','290','10','136');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('36','semper','Boeing','209','7','124');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('37','turpis.','Dassault','326','4','148');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('38','vitae','Boeing','358','5','123');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('39','nec,','Airbus','224','9','87');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('40','nulla','Airbus','324','10','136');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('41','amet','Boeing','394','8','84');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('42','nunc.','Dassault','252','9','101');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('43','non','Airbus','367','8','105');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('44','vulputate','Dassault','397','10','102');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('45','ornare','Boeing','229','7','87');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('46','Sed','Airbus','362','6','128');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('47','elit,','Boeing','290','6','143');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('48','Curabitur','Dassault','282','4','85');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('49','rutrum','Airbus','379','8','123');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('50','lobortis','Boeing','318','8','140');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('51','enim,','Boeing','214','7','129');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('52','penatibus','Airbus','398','10','93');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('53','eleifend,','Dassault','347','5','149');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('54','metus','Airbus','359','7','91');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('55','eu','Boeing','284','8','113');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('56','arcu','Dassault','366','4','88');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('57','nec','Airbus','202','7','135');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('58','amet','Airbus','360','5','128');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('59','urna.','Dassault','334','9','90');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('60','orci,','Airbus','378','8','140');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('61','magna.','Airbus','286','9','144');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('62','malesuada','Boeing','309','6','89');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('63','nonummy.','Airbus','298','8','143');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('64','mollis','Dassault','381','5','145');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('65','Nullam','Airbus','366','6','132');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('66','lacus.','Airbus','226','7','103');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('67','lorem,','Boeing','203','5','143');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('68','augue','Boeing','208','8','91');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('69','dui.','Dassault','350','5','90');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('70','libero','Airbus','341','5','133');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('71','lorem','Boeing','338','9','145');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('72','In','Boeing','207','7','91');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('73','tellus','Dassault','263','8','85');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('74','ligula','Airbus','389','4','89');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('75','magna.','Dassault','384','8','99');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('76','elit.','Boeing','379','7','120');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('77','nulla','Airbus','391','10','120');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('78','dis','Dassault','348','8','106');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('79','Curabitur','Dassault','222','7','128');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('80','urna.','Airbus','243','4','147');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('81','cursus','Airbus','350','8','85');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('82','dolor','Boeing','225','9','148');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('83','gravida','Boeing','284','9','81');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('84','ante','Airbus','295','6','117');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('85','nec','Boeing','237','9','82');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('86','porttitor','Boeing','304','8','80');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('87','mattis','Airbus','294','8','108');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('88','Nullam','Airbus','269','10','96');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('89','pede','Airbus','286','7','92');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('90','Aenean','Dassault','393','4','148');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('91','sapien,','Dassault','280','9','113');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('92','nascetur','Boeing','267','7','123');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('93','Aenean','Boeing','283','5','88');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('94','lorem','Dassault','391','7','86');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('95','Praesent','Dassault','257','5','130');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('96','dui.','Dassault','329','10','124');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('97','tincidunt','Boeing','290','8','83');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('98','primis','Dassault','280','4','138');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('99','Nulla','Airbus','301','8','128');
- INSERT INTO TP2.AVION (IMMATRICULATION,NOM,CONSTRUCTEUR,CAPACITE,NOMBRE_REACTEURS,LARGEUR) VALUES ('100','odio','Boeing','280','7','102');
- REM INSERTING INTO TP2.PASSAGER
- SET DEFINE OFF;
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('2','Berg','Shelby','109','22');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('3','Fisher','Cora','104','26');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('5','Moses','Ashton','84','20');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('6','Clarke','Priscilla','70','20');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('7','Downs','Kamal','78','58');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('8','Lamb','Colette','91','33');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('9','Becker','Cora','70','29');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('10','Rivera','Grant','72','31');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('11','Lester','Cora','93','59');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('13','Kinney','Kennedy','95','59');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('14','Buck','Ahmed','107','57');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('15','Mullins','Giselle','87','34');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('16','Harrell','Clementine','46','17');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('17','Hester','Callie','107','38');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('18','Collins','Reagan','90','30');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('19','Mathis','Dai','60','45');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('20','Gilbert','Kirk','101','60');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('21','Conley','Carson','48','13');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('22','Herring','Brenna','102','23');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('24','Reeves','Wallace','105','49');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('25','Wilkerson','Risa','75','31');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('26','Mayer','Regan','79','38');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('27','Brock','Jeremy','92','32');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('28','Romero','MacKensie','93','10');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('30','Chang','Sawyer','71','21');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('31','Wade','Charles','105','28');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('32','Parsons','Danielle','98','59');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('33','Norton','Carol','84','19');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('34','Jacobs','Alice','59','37');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('35','Baxter','Quinn','52','26');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('36','Griffith','Wayne','77','27');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('37','Thomas','Galena','53','57');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('38','Goodman','Jeremy','96','32');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('40','Guy','Vivien','71','31');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('41','Hodge','Kirestin','103','43');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('42','Mullins','Tara','103','25');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('43','Mcleod','Scarlett','54','44');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('44','Barber','Gloria','76','19');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('45','Cantu','Owen','67','58');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('46','Wyatt','Xenos','102','34');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('48','Wilson','Dai','52','29');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('49','Randolph','John','102','13');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('50','Brewer','Chandler','60','52');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('51','Osborn','Rhoda','47','55');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('52','Montgomery','Sloane','88','23');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('53','Velez','Hermione','47','26');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('54','Bryant','Sandra','88','53');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('55','Bolton','Zachary','52','60');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('59','Preston','Eagan','70','22');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('60','Alston','Guy','72','49');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('62','Potts','Jessamine','70','39');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('63','Myers','Alice','51','39');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('64','Gay','Samson','55','45');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('65','Mckenzie','Carly','62','33');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('66','Reese','Harding','63','37');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('67','Baldwin','Rina','57','16');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('68','Mcleod','Bevis','89','37');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('69','Edwards','Brett','76','11');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('70','Mcdonald','Leilani','99','58');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('71','Figueroa','Mollie','88','31');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('72','Combs','Kameko','97','31');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('73','Collier','Hall','67','37');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('74','Poole','Jena','92','29');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('75','Greene','Jamalia','94','52');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('76','Watson','Dora','88','53');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('77','Francis','Wynne','99','38');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('78','Griffin','Nicole','63','60');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('79','Baxter','Timothy','52','57');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('80','Ferrell','Xerxes','88','49');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('81','Hoffman','Quintessa','90','36');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('82','Gutierrez','Megan','89','32');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('83','Orr','Nadine','77','14');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('85','Ware','Teegan','75','19');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('86','Mercer','Jermaine','96','14');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('87','Elliott','Urielle','54','39');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('88','Valencia','Aidan','49','33');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('89','Gallagher','Ariel','74','54');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('90','Dixon','Leilani','76','20');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('91','Shannon','Margaret','82','19');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('92','Joyner','Calvin','71','10');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('93','Reilly','Abbot','52','44');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('94','Crosby','Kristen','80','11');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('95','Wright','Eagan','82','51');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('96','Roy','Addison','47','41');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('97','Chavez','Lyle','48','45');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('98','Lewis','Edward','62','41');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('100','Obrien','Meredith','57','53');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('101','Vaughn','Geraldine','107','16');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('102','White','Iris','69','33');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('103','Wade','Karly','89','40');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('104','Koch','David','95','59');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('105','Tucker','Sarah','98','26');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('106','Hudson','Leo','107','26');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('107','Whitfield','Jael','49','33');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('108','Jordan','Cleo','98','29');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('109','Schroeder','Connor','58','39');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('110','Albert','Illiana','77','42');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('111','Castro','Alfreda','97','23');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('112','Turner','Sloane','89','15');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('113','Cain','Emily','54','38');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('114','Morgan','Stephen','74','13');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('115','Holland','Britanney','76','55');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('116','Bailey','Raven','64','16');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('117','Phelps','Inga','84','18');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('118','Mosley','Karyn','79','21');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('119','Hutchinson','Marah','55','18');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('120','Cantrell','Jared','91','40');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('121','Shepard','Sigourney','70','26');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('122','Chavez','Claudia','93','26');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('123','Reid','Winter','66','45');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('124','Osborn','Zelda','102','58');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('125','Schroeder','Alfreda','58','20');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('126','Nunez','Lance','74','38');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('127','Whitehead','Rudyard','62','18');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('128','West','Blaze','102','12');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('129','Brown','Wanda','100','14');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('130','Davidson','Bethany','99','33');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('131','Curry','Robert','83','16');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('132','Branch','Uriel','106','33');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('133','Cochran','Charde','99','43');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('134','Flores','Vanna','79','17');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('136','Hancock','Farrah','105','16');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('137','Lang','Zoe','53','15');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('138','Maddox','Jeanette','100','40');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('139','Horn','Nolan','74','20');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('140','Kramer','Constance','69','12');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('141','Townsend','Caleb','82','52');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('142','Monroe','Hyatt','72','39');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('143','Morse','Brenna','97','13');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('144','Rosa','Azalia','110','51');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('145','Buckley','Xavier','50','16');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('146','Thompson','Elijah','68','25');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('147','Barry','Elvis','81','41');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('148','Galloway','Moana','51','18');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('149','House','Aubrey','108','14');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('150','Bauer','Kirby','102','58');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('151','Petersen','Adrian','60','41');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('152','Vega','Orla','50','34');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('153','Wheeler','Cody','68','52');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('154','Jarvis','Adrian','85','36');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('155','Tran','Herrod','72','32');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('156','Fletcher','Alma','56','37');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('157','Mercer','Rafael','81','52');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('158','Valencia','Dennis','60','29');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('159','Rosales','Alec','98','34');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('160','Daugherty','Rina','89','37');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('161','Bell','Tanek','52','44');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('162','Wilkerson','Tobias','77','20');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('163','Ratliff','Ray','107','23');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('164','Shepard','Victoria','68','29');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('165','Norton','Hop','50','36');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('166','Stevenson','Dominique','103','23');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('167','Shelton','Cairo','48','52');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('168','Callahan','Sheila','87','58');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('169','Lawson','Ciaran','47','38');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('170','Horn','August','100','21');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('171','Pollard','Bethany','93','18');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('172','Patton','Daquan','83','60');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('173','Holt','Kaye','88','50');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('174','Adams','Velma','95','43');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('175','Solis','Brent','100','21');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('176','Waters','Erin','59','23');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('177','Mccarthy','Drew','93','42');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('178','Pierce','Lester','53','42');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('179','Mclean','Cameron','93','17');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('180','Hunter','Armando','52','22');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('181','Morin','Dai','69','13');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('182','Deleon','Kelsey','81','24');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('183','Rivera','Odysseus','95','19');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('184','Clarke','Hayes','88','40');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('185','Foreman','Jennifer','82','25');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('186','Hickman','Cleo','98','33');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('187','Townsend','Stone','104','18');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('188','Robles','Eagan','98','39');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('190','Davidson','Coby','92','27');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('191','Leon','Chaim','60','10');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('192','Perry','Reece','77','42');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('193','Weber','Michael','107','40');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('194','Hopper','Alisa','59','10');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('195','Sykes','Jennifer','51','10');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('196','Mcleod','Heather','108','17');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('197','Hays','Lev','61','14');
- INSERT INTO TP2.PASSAGER (ID,NOM,PRENOM,POIDS,VOL) VALUES ('200','Burnett','Yardley','106','51');
- REM INSERTING INTO TP2.VILLE
- SET DEFINE OFF;
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Hameln','965220 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Klosterneuburg','61-220 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Sint-Kwintens-Lennik','21617 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Durg','00-484 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Mérignac','70-068 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Chester','12971 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Sanzeno','31976 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Verrayes','96298 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Konin','7069XL ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('LamontzŽe','4847 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Sant''Angelo in Pontano','21413 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Sivry-Rance','577034 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Forgaria nel Friuli','L3M 4E0 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Caprino Bergamasco','4435 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Conca Casale','1092 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Chalon-sur-Saône','48696 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Jambes','E3S 6ES ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Donk','709518 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Leut','M2A 3Z0 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Ã…kersberga','44-477 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Grumo Appula','465748 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Gaspo','5159 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Les Bons Villers','19608 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Delft','7558FO ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Calgary','46897 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Erpion','87810 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Queanbeyan','224053 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Ekeren','77557 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('ValparaÃso','39-765 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Uppingham. Cottesmore','931173 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Langen','59291 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Madison','67820 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('RÃo Bueno','B2T 6X0 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Saint-Vincent','14021 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Nagpur','33914 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Aylmer','79049 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Loksbergen','379561 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Helena','6198 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Leganés','81048 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Fossato Serralta','13979 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Hennigsdorf','2840 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Jalgaon','Z6O 1ZO ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Sambhal','4589 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Folkestone','9763 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Paignton','9215 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Lanklaar','5157 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Scorrano','1377 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Pont-ˆ-Celles','75441 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Haverfordwest','842449 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Vetlanda','91632-674 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Rutland','00715 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Castel San Niccolò','91983 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Chicoutimi','46353 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Liedekerke','8660 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Pointe-du-Lac','40414 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Posina','56596 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Halberstadt','13383 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Rezzoaglio','55447 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Arvier','52443 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Barra do Corda','26339 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Leugnies','606407 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Fort Worth','XI4 8HJ ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('West Valley City','70117 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Izel','73-361 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Dornoch','3469 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Leval-Chaudeville','15901 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Mandela','965654 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Ponte nelle Alpi','2934 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Lakewood','70474-443 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Sant''Arsenio','04426 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Igboho','90633 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Enines','126240 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Sint-Stevens-Woluwe','7947 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Soissons','771094 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Kampenhout','29095-811 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Louisville','70772-246 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Moustier-sur-Sambre','0059SJ ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Krishnanagar','L4J 0W3 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Jennersdorf','20218 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Magdeburg','3578 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Hines Creek','71823 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Sale','03541 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Leke','34093 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Sossano','909103 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Raj Nandgaon','0901 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Lutterworth','S2W 1M8 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Lozzo Atestino','51412 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Beaumont','6347 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Lüneburg','71507 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Tiltil','9351 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Palagano','9958 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('San Piero Patti','59641 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Philadelphia','P0C 6A9 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Lac Ste. Anne','40515 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Hearst','73430 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Leeds','07520 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Santa Croce sull''Arno','7460 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Orroli','6184 ');
- INSERT INTO TP2.VILLE (NOM,CODE_POSTAL) VALUES ('Rosières','2725LL ');
- REM INSERTING INTO TP2.VOL
- SET DEFINE OFF;
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('1','pede blandit congue. In scelerisque','709518 ','40515 ','82',TO_DATE('04/10/16','DD/MM/RR'),NULL,'91');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('2','Suspendisse aliquet, sem ut cursus','965220 ','75441 ','63',TO_DATE('08/04/15','DD/MM/RR'),NULL,'152');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('3','purus. Maecenas libero est, congue','39-765 ','909103 ','83',TO_DATE('23/08/15','DD/MM/RR'),NULL,'106');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('4','blandit. Nam nulla magna, malesuada','39-765 ','75441 ','13',TO_DATE('12/06/16','DD/MM/RR'),NULL,'71');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('5','massa. Suspendisse eleifend. Cras sed','709518 ','46353 ','42',TO_DATE('03/01/16','DD/MM/RR'),NULL,'106');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('6','at arcu. Vestibulum ante ipsum','7069XL ','40515 ','49',TO_DATE('02/06/15','DD/MM/RR'),NULL,'61');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('7','adipiscing ligula. Aenean gravida nunc','21617 ','4589 ','46',TO_DATE('18/09/16','DD/MM/RR'),NULL,'93');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('8','eget tincidunt dui augue eu','39-765 ','909103 ','78',TO_DATE('05/08/16','DD/MM/RR'),NULL,'162');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('9','non arcu. Vivamus sit amet','21617 ','75441 ','39',TO_DATE('04/03/17','DD/MM/RR'),NULL,'154');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('10','ligula. Nullam enim. Sed nulla','21617 ','40515 ','49',TO_DATE('18/10/16','DD/MM/RR'),NULL,'68');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('11','non, luctus sit amet, faucibus','39-765 ','909103 ','66',TO_DATE('17/01/17','DD/MM/RR'),NULL,'121');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('12','Maecenas iaculis aliquet diam. Sed','577034 ','40515 ','21',TO_DATE('02/10/15','DD/MM/RR'),NULL,'81');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('13','ac libero nec ligula consectetuer','965220 ','75441 ','89',TO_DATE('17/03/17','DD/MM/RR'),NULL,'119');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('14','ante, iaculis nec, eleifend non,','39-765 ','2725LL ','26',TO_DATE('26/03/15','DD/MM/RR'),NULL,'133');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('15','et ultrices posuere cubilia Curae;','709518 ','909103 ','58',TO_DATE('01/05/16','DD/MM/RR'),NULL,'61');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('16','at fringilla purus mauris a','577034 ','46353 ','33',TO_DATE('09/04/15','DD/MM/RR'),NULL,'86');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('17','faucibus orci luctus et ultrices','21617 ','75441 ','26',TO_DATE('13/12/15','DD/MM/RR'),NULL,'124');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('18','Cras eu tellus eu augue','577034 ','91632-674 ','39',TO_DATE('14/01/17','DD/MM/RR'),NULL,'168');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('19','ligula. Aenean gravida nunc sed','19608 ','91632-674 ','15',TO_DATE('25/02/17','DD/MM/RR'),NULL,'102');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('20','lacus. Quisque purus sapien, gravida','21617 ','2725LL ','65',TO_DATE('18/08/15','DD/MM/RR'),NULL,'165');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('21','consequat auctor, nunc nulla vulputate','39-765 ','40515 ','54',TO_DATE('04/01/16','DD/MM/RR'),NULL,'62');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('22','gravida non, sollicitudin a, malesuada','39-765 ','2725LL ','73',TO_DATE('14/09/15','DD/MM/RR'),NULL,'126');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('23','pharetra. Quisque ac libero nec','577034 ','2725LL ','67',TO_DATE('08/12/16','DD/MM/RR'),NULL,'198');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('24','a, enim. Suspendisse aliquet, sem','7069XL ','4589 ','78',TO_DATE('25/02/16','DD/MM/RR'),NULL,'190');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('25','risus. Donec egestas. Duis ac','709518 ','2725LL ','13',TO_DATE('01/03/17','DD/MM/RR'),NULL,'91');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('26','cursus et, eros. Proin ultrices.','7069XL ','75441 ','31',TO_DATE('09/03/17','DD/MM/RR'),NULL,'157');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('27','dictum placerat, augue. Sed molestie.','39-765 ','4589 ','50',TO_DATE('03/05/15','DD/MM/RR'),NULL,'140');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('28','Nulla eu neque pellentesque massa','965220 ','91632-674 ','72',TO_DATE('03/04/15','DD/MM/RR'),NULL,'116');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('29','viverra. Maecenas iaculis aliquet diam.','21617 ','2725LL ','27',TO_DATE('17/04/16','DD/MM/RR'),NULL,'197');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('30','fames ac turpis egestas. Aliquam','39-765 ','46353 ','54',TO_DATE('31/01/16','DD/MM/RR'),NULL,'121');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('31','erat eget ipsum. Suspendisse sagittis.','39-765 ','2725LL ','87',TO_DATE('05/05/16','DD/MM/RR'),NULL,'142');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('32','nunc. In at pede. Cras','39-765 ','4589 ','86',TO_DATE('28/03/15','DD/MM/RR'),NULL,'120');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('33','et, rutrum non, hendrerit id,','39-765 ','909103 ','63',TO_DATE('16/01/16','DD/MM/RR'),NULL,'100');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('34','lacus. Quisque purus sapien, gravida','19608 ','2725LL ','39',TO_DATE('19/02/16','DD/MM/RR'),NULL,'98');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('35','enim. Nunc ut erat. Sed','7069XL ','75441 ','80',TO_DATE('04/04/16','DD/MM/RR'),NULL,'137');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('36','vel arcu. Curabitur ut odio','21617 ','91632-674 ','41',TO_DATE('12/10/15','DD/MM/RR'),NULL,'145');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('37','ac tellus. Suspendisse sed dolor.','39-765 ','4589 ','30',TO_DATE('15/09/16','DD/MM/RR'),NULL,'179');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('38','malesuada fames ac turpis egestas.','39-765 ','4589 ','60',TO_DATE('25/05/16','DD/MM/RR'),NULL,'155');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('39','convallis ligula. Donec luctus aliquet','39-765 ','2725LL ','32',TO_DATE('24/05/16','DD/MM/RR'),NULL,'129');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('40','Donec tincidunt. Donec vitae erat','709518 ','4589 ','14',TO_DATE('08/02/16','DD/MM/RR'),NULL,'108');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('41','diam luctus lobortis. Class aptent','39-765 ','2725LL ','70',TO_DATE('04/12/16','DD/MM/RR'),NULL,'176');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('42','tortor nibh sit amet orci.','709518 ','91632-674 ','42',TO_DATE('20/04/15','DD/MM/RR'),NULL,'80');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('43','Integer aliquam adipiscing lacus. Ut','965220 ','2725LL ','11',TO_DATE('27/02/16','DD/MM/RR'),NULL,'155');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('44','metus. Vivamus euismod urna. Nullam','39-765 ','75441 ','47',TO_DATE('07/08/16','DD/MM/RR'),NULL,'103');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('45','molestie. Sed id risus quis','39-765 ','2725LL ','24',TO_DATE('07/05/15','DD/MM/RR'),NULL,'171');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('46','consequat auctor, nunc nulla vulputate','19608 ','4589 ','41',TO_DATE('18/06/16','DD/MM/RR'),NULL,'141');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('49','suscipit, est ac facilisis facilisis,','39-765 ','40515 ','79',TO_DATE('28/09/16','DD/MM/RR'),NULL,'183');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('50','amet, consectetuer adipiscing elit. Etiam','39-765 ','40515 ','45',TO_DATE('27/08/15','DD/MM/RR'),NULL,'88');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('51','arcu. Morbi sit amet massa.','19608 ','2725LL ','45',TO_DATE('04/01/17','DD/MM/RR'),NULL,'130');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('52','penatibus et magnis dis parturient','709518 ','909103 ','41',TO_DATE('11/04/16','DD/MM/RR'),NULL,'75');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('53','dictum. Phasellus in felis. Nulla','7069XL ','909103 ','44',TO_DATE('04/02/17','DD/MM/RR'),NULL,'185');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('54','nec tellus. Nunc lectus pede,','965220 ','91632-674 ','22',TO_DATE('02/12/16','DD/MM/RR'),NULL,'125');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('55','nibh. Phasellus nulla. Integer vulputate,','7069XL ','4589 ','45',TO_DATE('12/04/16','DD/MM/RR'),NULL,'112');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('57','ullamcorper. Duis at lacus. Quisque','709518 ','46353 ','87',TO_DATE('05/05/15','DD/MM/RR'),NULL,'124');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('58','laoreet ipsum. Curabitur consequat, lectus','21617 ','2725LL ','24',TO_DATE('19/06/15','DD/MM/RR'),NULL,'192');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('59','tristique aliquet. Phasellus fermentum convallis','577034 ','46353 ','46',TO_DATE('18/08/16','DD/MM/RR'),NULL,'163');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('60','mi lacinia mattis. Integer eu','7069XL ','4589 ','51',TO_DATE('07/11/16','DD/MM/RR'),NULL,'85');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('61','lorem vitae odio sagittis semper.','39-765 ','91632-674 ','69',TO_DATE('26/07/15','DD/MM/RR'),NULL,'79');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('62','lacus pede sagittis augue, eu','39-765 ','40515 ','21',TO_DATE('16/11/16','DD/MM/RR'),NULL,'69');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('63','non, lobortis quis, pede. Suspendisse','21617 ','75441 ','50',TO_DATE('14/11/16','DD/MM/RR'),NULL,'95');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('64','fringilla, porttitor vulputate, posuere vulputate,','39-765 ','91632-674 ','90',TO_DATE('08/06/15','DD/MM/RR'),NULL,'197');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('65','Donec dignissim magna a tortor.','39-765 ','75441 ','71',TO_DATE('17/03/16','DD/MM/RR'),NULL,'86');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('67','at arcu. Vestibulum ante ipsum','39-765 ','46353 ','86',TO_DATE('25/05/15','DD/MM/RR'),NULL,'180');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('68','vel, mauris. Integer sem elit,','39-765 ','75441 ','64',TO_DATE('10/08/16','DD/MM/RR'),NULL,'87');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('69','est ac mattis semper, dui','39-765 ','909103 ','87',TO_DATE('11/10/16','DD/MM/RR'),NULL,'179');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('71','dui, in sodales elit erat','965220 ','40515 ','35',TO_DATE('30/08/15','DD/MM/RR'),NULL,'84');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('72','Integer vulputate, risus a ultricies','39-765 ','909103 ','43',TO_DATE('24/06/16','DD/MM/RR'),NULL,'148');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('73','primis in faucibus orci luctus','577034 ','909103 ','16',TO_DATE('27/05/16','DD/MM/RR'),NULL,'192');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('74','convallis est, vitae sodales nisi','709518 ','46353 ','57',TO_DATE('08/10/16','DD/MM/RR'),NULL,'108');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('76','Morbi neque tellus, imperdiet non,','39-765 ','4589 ','40',TO_DATE('24/08/15','DD/MM/RR'),NULL,'128');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('77','nonummy ultricies ornare, elit elit','19608 ','2725LL ','46',TO_DATE('19/11/15','DD/MM/RR'),NULL,'90');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('78','lacus, varius et, euismod et,','709518 ','46353 ','74',TO_DATE('26/08/15','DD/MM/RR'),NULL,'87');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('79','vel turpis. Aliquam adipiscing lobortis','21617 ','2725LL ','89',TO_DATE('07/08/15','DD/MM/RR'),NULL,'67');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('80','sed dictum eleifend, nunc risus','7069XL ','46353 ','10',TO_DATE('27/11/16','DD/MM/RR'),NULL,'158');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('81','fringilla mi lacinia mattis. Integer','7069XL ','2725LL ','22',TO_DATE('12/07/16','DD/MM/RR'),NULL,'73');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('82','Donec dignissim magna a tortor.','21617 ','91632-674 ','26',TO_DATE('20/11/16','DD/MM/RR'),NULL,'56');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('84','nec, euismod in, dolor. Fusce','39-765 ','909103 ','57',TO_DATE('28/11/16','DD/MM/RR'),NULL,'150');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('85','parturient montes, nascetur ridiculus mus.','577034 ','91632-674 ','33',TO_DATE('23/04/15','DD/MM/RR'),NULL,'122');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('86','ligula elit, pretium et, rutrum','21617 ','4589 ','58',TO_DATE('11/01/16','DD/MM/RR'),NULL,'96');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('87','semper pretium neque. Morbi quis','39-765 ','2725LL ','88',TO_DATE('19/12/16','DD/MM/RR'),NULL,'171');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('88','dui, in sodales elit erat','965220 ','46353 ','68',TO_DATE('25/10/15','DD/MM/RR'),NULL,'89');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('89','quis arcu vel quam dignissim','39-765 ','46353 ','38',TO_DATE('25/01/17','DD/MM/RR'),NULL,'146');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('90','magna a neque. Nullam ut','19608 ','91632-674 ','79',TO_DATE('14/02/16','DD/MM/RR'),NULL,'107');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('91','non dui nec urna suscipit','39-765 ','40515 ','56',TO_DATE('23/11/15','DD/MM/RR'),NULL,'185');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('92','Pellentesque ultricies dignissim lacus. Aliquam','39-765 ','46353 ','11',TO_DATE('14/12/15','DD/MM/RR'),NULL,'121');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('93','ut mi. Duis risus odio,','19608 ','2725LL ','70',TO_DATE('26/02/16','DD/MM/RR'),NULL,'114');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('94','ullamcorper magna. Sed eu eros.','709518 ','91632-674 ','36',TO_DATE('23/04/16','DD/MM/RR'),NULL,'95');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('95','scelerisque neque. Nullam nisl. Maecenas','39-765 ','2725LL ','46',TO_DATE('06/09/16','DD/MM/RR'),NULL,'189');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('96','egestas nunc sed libero. Proin','965220 ','2725LL ','44',TO_DATE('28/11/15','DD/MM/RR'),NULL,'197');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('97','egestas hendrerit neque. In ornare','7069XL ','40515 ','57',TO_DATE('19/04/16','DD/MM/RR'),NULL,'144');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('98','ipsum primis in faucibus orci','709518 ','46353 ','39',TO_DATE('01/04/15','DD/MM/RR'),NULL,'67');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('99','a neque. Nullam ut nisi','39-765 ','46353 ','35',TO_DATE('21/11/16','DD/MM/RR'),NULL,'157');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('100','penatibus et magnis dis parturient','965220 ','4589 ','79',TO_DATE('11/09/16','DD/MM/RR'),NULL,'60');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('101','Cras eu tellus eu augue','709518 ','75441 ','75',TO_DATE('21/06/15','DD/MM/RR'),NULL,'81');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('102','ultricies dignissim lacus. Aliquam rutrum','965220 ','909103 ','12',TO_DATE('15/12/15','DD/MM/RR'),NULL,'196');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('103','consequat nec, mollis vitae, posuere','19608 ','2725LL ','33',TO_DATE('19/01/16','DD/MM/RR'),NULL,'159');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('104','sit amet metus. Aliquam erat','19608 ','2725LL ','22',TO_DATE('24/08/15','DD/MM/RR'),NULL,'112');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('105','enim diam vel arcu. Curabitur','577034 ','4589 ','22',TO_DATE('18/06/15','DD/MM/RR'),NULL,'95');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('106','urna justo faucibus lectus, a','709518 ','40515 ','14',TO_DATE('06/04/16','DD/MM/RR'),NULL,'117');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('107','et magnis dis parturient montes,','577034 ','75441 ','37',TO_DATE('04/04/16','DD/MM/RR'),NULL,'78');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('108','quis turpis vitae purus gravida','39-765 ','75441 ','68',TO_DATE('29/09/16','DD/MM/RR'),NULL,'185');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('109','Curabitur vel lectus. Cum sociis','19608 ','91632-674 ','23',TO_DATE('05/05/15','DD/MM/RR'),NULL,'73');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('110','ante lectus convallis est, vitae','19608 ','40515 ','11',TO_DATE('13/04/15','DD/MM/RR'),NULL,'157');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('111','adipiscing elit. Curabitur sed tortor.','39-765 ','40515 ','75',TO_DATE('02/02/16','DD/MM/RR'),NULL,'83');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('112','cubilia Curae; Donec tincidunt. Donec','39-765 ','2725LL ','33',TO_DATE('07/09/16','DD/MM/RR'),NULL,'193');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('113','erat nonummy ultricies ornare, elit','709518 ','909103 ','23',TO_DATE('04/03/17','DD/MM/RR'),NULL,'94');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('114','vestibulum massa rutrum magna. Cras','709518 ','909103 ','56',TO_DATE('08/07/15','DD/MM/RR'),NULL,'116');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('115','pede blandit congue. In scelerisque','709518 ','40515 ','52',TO_DATE('02/03/16','DD/MM/RR'),NULL,'167');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('116','viverra. Donec tempus, lorem fringilla','577034 ','2725LL ','67',TO_DATE('20/01/17','DD/MM/RR'),NULL,'192');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('117','in lobortis tellus justo sit','709518 ','909103 ','29',TO_DATE('11/01/16','DD/MM/RR'),NULL,'110');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('118','ornare lectus justo eu arcu.','7069XL ','4589 ','65',TO_DATE('05/02/17','DD/MM/RR'),NULL,'120');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('119','faucibus orci luctus et ultrices','709518 ','75441 ','55',TO_DATE('29/07/15','DD/MM/RR'),NULL,'121');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('120','auctor velit. Aliquam nisl. Nulla','577034 ','4589 ','71',TO_DATE('11/11/16','DD/MM/RR'),NULL,'60');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('121','mattis semper, dui lectus rutrum','19608 ','75441 ','68',TO_DATE('16/06/16','DD/MM/RR'),NULL,'168');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('122','Pellentesque ultricies dignissim lacus. Aliquam','39-765 ','4589 ','83',TO_DATE('18/05/15','DD/MM/RR'),NULL,'117');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('123','neque tellus, imperdiet non, vestibulum','7069XL ','91632-674 ','37',TO_DATE('03/01/16','DD/MM/RR'),NULL,'190');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('124','Cum sociis natoque penatibus et','39-765 ','4589 ','76',TO_DATE('10/04/16','DD/MM/RR'),NULL,'95');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('125','vulputate eu, odio. Phasellus at','577034 ','2725LL ','24',TO_DATE('19/01/17','DD/MM/RR'),NULL,'138');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('126','dignissim pharetra. Nam ac nulla.','39-765 ','4589 ','15',TO_DATE('02/11/16','DD/MM/RR'),NULL,'144');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('127','velit dui, semper et, lacinia','39-765 ','46353 ','45',TO_DATE('20/01/17','DD/MM/RR'),NULL,'154');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('128','mauris elit, dictum eu, eleifend','39-765 ','75441 ','12',TO_DATE('04/12/16','DD/MM/RR'),NULL,'153');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('129','Etiam vestibulum massa rutrum magna.','39-765 ','40515 ','84',TO_DATE('01/02/17','DD/MM/RR'),NULL,'97');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('130','et malesuada fames ac turpis','39-765 ','4589 ','57',TO_DATE('13/11/15','DD/MM/RR'),NULL,'108');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('131','ut nisi a odio semper','21617 ','2725LL ','40',TO_DATE('09/07/15','DD/MM/RR'),NULL,'117');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('132','semper egestas, urna justo faucibus','39-765 ','46353 ','10',TO_DATE('04/04/15','DD/MM/RR'),NULL,'91');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('133','id magna et ipsum cursus','577034 ','4589 ','31',TO_DATE('17/01/16','DD/MM/RR'),NULL,'101');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('134','eleifend non, dapibus rutrum, justo.','7069XL ','2725LL ','26',TO_DATE('26/10/15','DD/MM/RR'),NULL,'113');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('135','varius. Nam porttitor scelerisque neque.','19608 ','4589 ','61',TO_DATE('24/08/15','DD/MM/RR'),NULL,'127');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('136','elementum purus, accumsan interdum libero','965220 ','91632-674 ','42',TO_DATE('09/12/15','DD/MM/RR'),NULL,'56');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('137','vehicula. Pellentesque tincidunt tempus risus.','21617 ','2725LL ','54',TO_DATE('11/12/16','DD/MM/RR'),NULL,'158');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('138','Aliquam ultrices iaculis odio. Nam','7069XL ','91632-674 ','59',TO_DATE('20/08/15','DD/MM/RR'),NULL,'173');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('139','nec urna et arcu imperdiet','21617 ','91632-674 ','39',TO_DATE('15/04/16','DD/MM/RR'),NULL,'59');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('140','eros nec tellus. Nunc lectus','39-765 ','91632-674 ','53',TO_DATE('27/11/16','DD/MM/RR'),NULL,'78');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('141','pede ac urna. Ut tincidunt','965220 ','40515 ','62',TO_DATE('14/09/15','DD/MM/RR'),NULL,'68');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('142','euismod est arcu ac orci.','39-765 ','46353 ','39',TO_DATE('28/05/16','DD/MM/RR'),NULL,'83');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('143','neque venenatis lacus. Etiam bibendum','965220 ','4589 ','36',TO_DATE('19/09/16','DD/MM/RR'),NULL,'182');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('144','Vivamus non lorem vitae odio','19608 ','91632-674 ','78',TO_DATE('05/04/15','DD/MM/RR'),NULL,'109');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('145','sodales at, velit. Pellentesque ultricies','7069XL ','75441 ','55',TO_DATE('28/01/16','DD/MM/RR'),NULL,'164');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('147','montes, nascetur ridiculus mus. Proin','7069XL ','4589 ','55',TO_DATE('17/06/15','DD/MM/RR'),NULL,'62');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('148','Phasellus fermentum convallis ligula. Donec','965220 ','40515 ','48',TO_DATE('01/09/16','DD/MM/RR'),NULL,'160');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('149','id, libero. Donec consectetuer mauris','577034 ','909103 ','40',TO_DATE('30/05/16','DD/MM/RR'),NULL,'147');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('150','erat, eget tincidunt dui augue','39-765 ','46353 ','80',TO_DATE('24/11/16','DD/MM/RR'),NULL,'174');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('151','ligula. Aenean gravida nunc sed','965220 ','46353 ','34',TO_DATE('14/07/16','DD/MM/RR'),NULL,'126');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('153','sapien molestie orci tincidunt adipiscing.','577034 ','2725LL ','41',TO_DATE('23/02/16','DD/MM/RR'),NULL,'145');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('154','Nullam nisl. Maecenas malesuada fringilla','39-765 ','909103 ','66',TO_DATE('28/07/15','DD/MM/RR'),NULL,'134');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('155','velit. Sed malesuada augue ut','7069XL ','909103 ','83',TO_DATE('04/04/15','DD/MM/RR'),NULL,'140');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('156','in faucibus orci luctus et','39-765 ','75441 ','25',TO_DATE('10/06/16','DD/MM/RR'),NULL,'189');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('157','Aliquam tincidunt, nunc ac mattis','709518 ','4589 ','49',TO_DATE('09/12/15','DD/MM/RR'),NULL,'103');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('158','ipsum dolor sit amet, consectetuer','19608 ','75441 ','84',TO_DATE('11/01/17','DD/MM/RR'),NULL,'73');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('159','a, scelerisque sed, sapien. Nunc','39-765 ','4589 ','73',TO_DATE('06/04/15','DD/MM/RR'),NULL,'177');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('160','ultrices posuere cubilia Curae; Donec','965220 ','75441 ','55',TO_DATE('31/05/16','DD/MM/RR'),NULL,'120');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('161','eu metus. In lorem. Donec','19608 ','46353 ','85',TO_DATE('01/11/16','DD/MM/RR'),NULL,'190');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('162','turpis. Aliquam adipiscing lobortis risus.','965220 ','46353 ','14',TO_DATE('29/03/16','DD/MM/RR'),NULL,'165');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('163','penatibus et magnis dis parturient','39-765 ','2725LL ','24',TO_DATE('20/11/15','DD/MM/RR'),NULL,'69');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('164','Donec sollicitudin adipiscing ligula. Aenean','965220 ','75441 ','18',TO_DATE('09/10/15','DD/MM/RR'),NULL,'122');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('165','est ac mattis semper, dui','21617 ','909103 ','83',TO_DATE('31/12/16','DD/MM/RR'),NULL,'166');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('166','lobortis, nisi nibh lacinia orci,','709518 ','91632-674 ','72',TO_DATE('06/06/15','DD/MM/RR'),NULL,'147');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('168','aliquet lobortis, nisi nibh lacinia','21617 ','2725LL ','63',TO_DATE('09/09/16','DD/MM/RR'),NULL,'129');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('169','lacinia at, iaculis quis, pede.','7069XL ','91632-674 ','26',TO_DATE('30/09/16','DD/MM/RR'),NULL,'108');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('170','a nunc. In at pede.','39-765 ','75441 ','75',TO_DATE('30/03/16','DD/MM/RR'),NULL,'62');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('171','gravida molestie arcu. Sed eu','39-765 ','909103 ','90',TO_DATE('27/01/17','DD/MM/RR'),NULL,'130');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('172','aliquet. Phasellus fermentum convallis ligula.','577034 ','75441 ','25',TO_DATE('03/07/15','DD/MM/RR'),NULL,'67');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('173','Quisque nonummy ipsum non arcu.','709518 ','40515 ','37',TO_DATE('12/05/15','DD/MM/RR'),NULL,'168');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('174','sit amet diam eu dolor','709518 ','2725LL ','53',TO_DATE('10/03/16','DD/MM/RR'),NULL,'122');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('175','nisi sem semper erat, in','39-765 ','75441 ','84',TO_DATE('24/01/16','DD/MM/RR'),NULL,'190');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('176','ipsum ac mi eleifend egestas.','39-765 ','4589 ','47',TO_DATE('25/07/16','DD/MM/RR'),NULL,'117');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('177','eleifend, nunc risus varius orci,','39-765 ','2725LL ','15',TO_DATE('02/01/17','DD/MM/RR'),NULL,'200');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('178','Nullam ut nisi a odio','965220 ','4589 ','52',TO_DATE('31/10/16','DD/MM/RR'),NULL,'109');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('179','sodales elit erat vitae risus.','39-765 ','46353 ','81',TO_DATE('07/05/15','DD/MM/RR'),NULL,'177');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('181','bibendum. Donec felis orci, adipiscing','965220 ','2725LL ','34',TO_DATE('05/04/15','DD/MM/RR'),NULL,'176');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('182','dignissim lacus. Aliquam rutrum lorem','577034 ','2725LL ','44',TO_DATE('02/09/15','DD/MM/RR'),NULL,'79');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('183','ut quam vel sapien imperdiet','709518 ','40515 ','10',TO_DATE('11/05/16','DD/MM/RR'),NULL,'121');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('184','amet, consectetuer adipiscing elit. Curabitur','709518 ','2725LL ','27',TO_DATE('27/11/16','DD/MM/RR'),NULL,'195');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('185','dictum placerat, augue. Sed molestie.','965220 ','91632-674 ','90',TO_DATE('19/07/15','DD/MM/RR'),NULL,'87');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('186','Nunc pulvinar arcu et pede.','39-765 ','40515 ','70',TO_DATE('17/12/15','DD/MM/RR'),NULL,'155');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('187','tellus justo sit amet nulla.','965220 ','91632-674 ','21',TO_DATE('25/10/15','DD/MM/RR'),NULL,'84');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('188','posuere, enim nisl elementum purus,','39-765 ','40515 ','56',TO_DATE('16/02/17','DD/MM/RR'),NULL,'128');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('189','nec, diam. Duis mi enim,','577034 ','40515 ','72',TO_DATE('23/12/16','DD/MM/RR'),NULL,'146');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('190','et ultrices posuere cubilia Curae;','577034 ','75441 ','61',TO_DATE('04/12/16','DD/MM/RR'),NULL,'152');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('191','ridiculus mus. Aenean eget magna.','19608 ','40515 ','11',TO_DATE('02/12/15','DD/MM/RR'),NULL,'185');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('192','Sed malesuada augue ut lacus.','709518 ','40515 ','34',TO_DATE('30/04/16','DD/MM/RR'),NULL,'58');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('193','nibh dolor, nonummy ac, feugiat','577034 ','91632-674 ','69',TO_DATE('26/12/15','DD/MM/RR'),NULL,'86');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('194','Nam consequat dolor vitae dolor.','39-765 ','46353 ','34',TO_DATE('17/03/17','DD/MM/RR'),NULL,'60');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('195','natoque penatibus et magnis dis','965220 ','40515 ','44',TO_DATE('17/06/15','DD/MM/RR'),NULL,'56');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('196','lorem semper auctor. Mauris vel','709518 ','75441 ','39',TO_DATE('02/02/17','DD/MM/RR'),NULL,'60');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('197','id enim. Curabitur massa. Vestibulum','39-765 ','40515 ','78',TO_DATE('23/02/16','DD/MM/RR'),NULL,'138');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('198','augue. Sed molestie. Sed id','19608 ','4589 ','56',TO_DATE('24/07/15','DD/MM/RR'),NULL,'151');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('199','vestibulum nec, euismod in, dolor.','7069XL ','40515 ','27',TO_DATE('20/12/16','DD/MM/RR'),NULL,'80');
- INSERT INTO TP2.VOL (ID,DESIGNATION,VILLE_ORIGINE,VILLE_ARRIVEE,AVION,DATE_DEPART,DATE_ARRIVEE,DUREE) VALUES ('200','est arcu ac orci. Ut','7069XL ','46353 ','16',TO_DATE('14/03/16','DD/MM/RR'),NULL,'123');
- --------------------------------------------------------
- -- Constraints for Table PASSAGER
- --------------------------------------------------------
- ALTER TABLE "TP2"."PASSAGER" ADD PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "SYSTEM" ENABLE;
- --------------------------------------------------------
- -- Constraints for Table VILLE
- --------------------------------------------------------
- ALTER TABLE "TP2"."VILLE" ADD PRIMARY KEY ("CODE_POSTAL")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "SYSTEM" ENABLE;
- --------------------------------------------------------
- -- Constraints for Table VOL
- --------------------------------------------------------
- ALTER TABLE "TP2"."VOL" ADD PRIMARY KEY ("ID")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "SYSTEM" ENABLE;
- --------------------------------------------------------
- -- Constraints for Table AVION
- --------------------------------------------------------
- ALTER TABLE "TP2"."AVION" ADD PRIMARY KEY ("IMMATRICULATION")
- USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
- STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
- PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
- TABLESPACE "SYSTEM" ENABLE;
- ALTER TABLE "TP2"."AVION" ADD CHECK (largeur>0) ENABLE;
- ALTER TABLE "TP2"."AVION" ADD CHECK (capacite>0) ENABLE;
- ALTER TABLE "TP2"."AVION" ADD CHECK ("NOMBRE_REACTEURS">0) ENABLE;
- --------------------------------------------------------
- -- Ref Constraints for Table PASSAGER
- --------------------------------------------------------
- ALTER TABLE "TP2"."PASSAGER" ADD FOREIGN KEY ("VOL")
- REFERENCES "TP2"."VOL" ("ID") ENABLE;
- --------------------------------------------------------
- -- Ref Constraints for Table VOL
- --------------------------------------------------------
- ALTER TABLE "TP2"."VOL" ADD FOREIGN KEY ("VILLE_ORIGINE")
- REFERENCES "TP2"."VILLE" ("CODE_POSTAL") ENABLE;
- ALTER TABLE "TP2"."VOL" ADD FOREIGN KEY ("VILLE_ARRIVEE")
- REFERENCES "TP2"."VILLE" ("CODE_POSTAL") ENABLE;
- ALTER TABLE "TP2"."VOL" ADD FOREIGN KEY ("AVION")
- REFERENCES "TP2"."AVION" ("IMMATRICULATION") ENABLE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement