INSERT INTO SUPPORT (SUP_CODE, SUP_INT) VALUES (1,'VHS');
INSERT INTO SUPPORT (SUP_CODE, SUP_INT) VALUES (2,'DVD');
INSERT INTO SUPPORT (SUP_CODE, SUP_INT) VALUES (3,'VCD');


INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (1,'Stallone','Sylvester');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (2,'Crenna','Richard');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (3,'Roberts','Eric');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (4,'Clavier','Christian');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (5,'Depardieu','Grard');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (6,'Redford','Robert');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (7,'Bouchez','Elodie');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (8,'Rgnier','Natacha');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (9,'Schwarzenegger','Arnold');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (10,'Connery','Sean');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (11,'Arquette','David');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (12,'Campbell','Neve');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (13,'Cox','Courteney');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (14,'Gibson','Mel');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (15,'Cruise','Tom');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (16,'Bronson','Charles');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (17,'Belmondo','Jean-Paul');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (18,'EastWood','Clint');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (19,'Stone','Sharon');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (20,'Englund','Robert');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (21,'Depp','Johnny');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (22,'Smith','Will');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (23,'Jugnot','Grard');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (24,'Lhermitte','Thierry');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (99,'Alastor','Sylvert');
INSERT INTO ACTEUR (ACT_CODE, ACT_NOM, ACT_PRENOM) VALUES (98,'Deneuve','Catherine');


INSERT INTO GENRE (GEN_CODE, GEN_INT) VALUES (1,'Action');
INSERT INTO GENRE (GEN_CODE, GEN_INT) VALUES (2,'Guerre');
INSERT INTO GENRE (GEN_CODE, GEN_INT) VALUES (3,'Comdie');
INSERT INTO GENRE (GEN_CODE, GEN_INT) VALUES (4,'Dessins-anims');
INSERT INTO GENRE (GEN_CODE, GEN_INT) VALUES (5,'Policier');
INSERT INTO GENRE (GEN_CODE, GEN_INT) VALUES (6,'Horreur');
INSERT INTO GENRE (GEN_CODE, GEN_INT) VALUES (7,'Western');
INSERT INTO GENRE (GEN_CODE, GEN_INT) VALUES (8,'Science-Fiction');
INSERT INTO GENRE (GEN_CODE, GEN_INT) VALUES (9,'Divers');


INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (2,'Rambo','1982',96,'Un ancien du VietNam confront  des policiers intransigeants.',1);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (3,'Best of the best 2','1992',97,NULL,1);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (4,'Astrix et Oblix contre Csar','1999',106,NULL,3);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (5,'The Faculty',NULL,101,'Un collge o les professeurs sont de vrais tueurs.',8);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (6,'Homme qui murmurait  l''oreille des chevaux (L'')','1998',163,'Un homme qui parle aux chevaux tente de sauver un cheval et sa cavalire.',9);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (7,'Vie rve des anges (La)','1998',109,'La vie de deux femmes perdues dans la socit.',9);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (8,'Haute voltige',NULL,108,'L''association de deux voleurs pour raliser le coup du sicle.',1);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (9,'Payback','1999',96,'Conflit entre truands.',5);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (10,'Silence des agneaux (le)','1990',120,NULL,5);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (11,'Couleur de l''argent (la)',NULL,NULL,'L''pope de deux joueurs de billard.',9);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (12,'Jean de florette','1986',120,NULL,9);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (13,'Manon des sources','1986',110,NULL,9);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (14,'Justicier de minuit (le)','1982',97,'A la recherche d''un tueur en srie.',5);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (15,'Police Python 357','1975',120,NULL,5);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (16,'Professionnel (le)','1981',115,'Un ancien soldat trahi par la nation revient pour se venger.',5);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (17,'Police academy','1984',95,'Une acadmie de police particulire. (Gags en srie)',3);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (18,'Soupe aux choux (la)','1981',88,NULL,3);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (19,'Silverado','1985',130,NULL,7);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (20,'Sept mercenaires (les)','1960',125,'Sept cowboys tentent de sauver un village de paysans.',7);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (21,'Bon, la brute et le truand (Le)','1966',160,'A la recherche d''un trsor sudiste.',7);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (22,'Apocalypse now','1979',152,NULL,2);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (23,'Canons de Navarone (les)','1961',155,'La victoire passe par la destruction d''normes canons.',2);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (24,'Dmons',NULL,NULL,'Des dmons envahissent un cinma.',6);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (25,'Dents de la mer (les)','1975',119,'Un requin blanc engendre la panique.',6);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (26,'Scream','1997',118,'Un tueur s''acharne contre une bande de jeunes collgiens.',6);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (27,'Blanche neige et les sept nains',NULL,NULL,NULL,4);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (28,'Merlin l''enchanteur',NULL,80,NULL,4);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (29,'Astrix et les indiens','1994',84,'Astrix et Oblix font connaissance des indiens.',4);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (30,'Akira','1988',124,NULL,4);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (31,'Aladdin','1992',90,'Aladdin et le gnie de la lampe.',4);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (32,'Judge Dredd','1994',92,'Un complot contre un super flic du futur.',8);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (33,'Bronzs font du ski (les)','1979',90,'Un groupe d''amis part en vacances de neige.',3);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (34,'Mutante (la)','1995',120,NULL,8);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (35,'Relve (La)','1991',120,'L''association de deux policiers : un jeune et un ancien ...',5);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (36,'Men In Black','1997',98,'Une seule solution contre les extra-terrestres : les Men In Black.',8);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (37,'Jug coupable',NULL,122,'Un journaliste tente de sauver un condamn  mort.',9);
INSERT INTO FILM (FLM_CODE,FLM_TITRE,FLM_ANNEE,FLM_DUREE,FLM_RESUME,GEN_CODE) VALUES (99,'Sirne du Mississipi (La)',1969,120,'Un industriel runionnais, Louis Mah, dcide de se marier par petites annonces',9);


INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (2,1);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (2,2);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (3,3);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (4,4);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (4,5);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (6,6);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (7,7);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (7,8);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (8,10);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (9,14);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (11,15);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (12,5);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (13,5);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (14,16);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (16,17);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (20,16);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (21,18);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (26,11);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (26,12);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (26,13);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (32,1);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (33,23);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (33,24);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (35,18);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (36,22);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (37,18);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (99,17);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (99,99);
INSERT INTO JOUER_UN_ROLE (FLM_CODE,ACT_CODE) VALUES (99,98);




INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (2,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (3,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (4,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (4,2);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (5,2);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (6,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (7,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (8,2);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (9,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (9,2);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (10,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (11,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (12,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (13,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (14,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (15,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (16,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (17,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (17,3);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (18,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (19,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (20,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (21,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (22,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (22,3);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (23,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (24,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (25,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (25,2);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (25,3);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (26,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (27,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (28,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (29,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (30,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (31,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (32,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (33,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (34,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (35,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (36,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (36,2);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (37,1);
INSERT INTO FILM_SUPPORT (FLM_CODE,SUP_CODE) VALUES (99,1);



INSERT INTO EMPRUNTEUR (PER_CODE,PER_NOM,PER_PRENOM,PER_ADR,PER_TEL) VALUES (1,'Payet','dominique','97400 SAINT DENIS','02.62.10.11.12');
INSERT INTO EMPRUNTEUR (PER_CODE,PER_NOM,PER_PRENOM,PER_ADR,PER_TEL) VALUES (2,'Hoarau','Pierre','97410 LE PORT','06.92.12.13.15');
INSERT INTO EMPRUNTEUR (PER_CODE,PER_NOM,PER_PRENOM,PER_ADR,PER_TEL) VALUES (3,'Grondin','Yann','97400 SAINT DENIS','06.92.10.11.16');
INSERT INTO EMPRUNTEUR (PER_CODE,PER_NOM,PER_PRENOM,PER_ADR,PER_TEL) VALUES (4,'Pajani','Alexandre','97419 LA POSSESSION','02.62.13.12.11');
INSERT INTO EMPRUNTEUR (PER_CODE,PER_NOM,PER_PRENOM,PER_ADR,PER_TEL) VALUES (5,'Grondin','Ivan','97420 SAINT PIERRE','02.62.32.33.34');


INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (2,1,'22-JAN-06','23-FEV-06');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (2,2,'01-DEC-01',NULL);
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (4,3,'02-FEV-02',NULL);
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (5,4,'08-JAN-02','15-JAN-02');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (5,5,'16-JAN-02','22-JAN-02');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (12,1,'05-JAN-02','22-JAN-02');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (12,2,'02-FEV-02',NULL);
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (12,3,'01-JUL-01','15-JUL-01');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (12,4,'01-AOU-01','15-AOU-01');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (12,5,'01-SEP-01','15-SEP-01');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (15,3,'06-FEV-02',NULL);	
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (22,3,'12-MAI-01','21-OCT-01');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (22,3,'10-FEV-02',NULL);
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (22,1,'18-NOV-01','28-NOV-01');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (23,5,'01-JAN-02','26-JAN-02');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (24,5,'01-JAN-02','26-JAN-02');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (25,4,'11-DEC-01',NULL);
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (32,4,'11-DEC-01',NULL);
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (32,3,'15-AOU-01','21-DEC-01');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (34,1,'22-JAN-01','22-JAN-01');
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (37,2,'29-DEC-01',NULL);
INSERT INTO EMPRUNT (FLM_CODE,PER_CODE,EMP_DEBUT,EMP_FIN) VALUES (99,4,'11-DEC-01',NULL);