API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 29th, 2019
134
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Oracle 11 51.38 KB | None | 0 0
raw download clone embed print report
  1. CONNECT / AS SYSDBA;
  2.  
  3. DROP USER olvoyage CASCADE;
  4.  
  5. CREATE USER olvoyage IDENTIFIED BY oracle;
  6.  
  7. ALTER USER olvoyage DEFAULT TABLESPACE users
  8.     QUOTA UNLIMITED ON users;
  9.  
  10. ALTER USER olvoyage TEMPORARY TABLESPACE temp;
  11.  
  12. GRANT CREATE SESSION,
  13.     CREATE TABLE,
  14.     CREATE PROCEDURE,
  15.     CREATE SEQUENCE,
  16.     CREATE TRIGGER,
  17.     CREATE VIEW,
  18.     CREATE SYNONYM,
  19.     ALTER SESSION
  20. TO olvoyage;
  21.  
  22. GRANT EXECUTE ON sys.dbms_stats TO olvoyage;
  23.  
  24. CONNECT olvoyage/oracle
  25.  
  26. -- create table,
  27. -- primary key, foreign key,
  28. -- sequence
  29. -- and checking constraint
  30.  
  31. CREATE TABLE T_PASS (
  32.     pass_id NUMBER(6) NOT NULL,
  33.     pass_name VARCHAR2(30) NOT NULL,
  34.     discount_pct NUMBER(2) NOT NULL,
  35.     discount_we_pct NUMBER(2) NOT NULL,
  36.     price NUMBER(8,2) NOT NULL,
  37.     CONSTRAINT PK_PASS PRIMARY KEY (pass_id)
  38. );
  39.  
  40. CREATE TABLE T_TICKET (
  41.     ticket_id NUMBER(6) NOT NULL,
  42.     seat NUMBER(3) NOT NULL,
  43.     customer_id NUMBER(6) NOT NULL,
  44.     wag_tr_id NUMBER(6) NOT NULL,
  45.     reservation_id NUMBER(6) NOT NULL,
  46.     direction VARCHAR2(10)
  47.     CONSTRAINT C_C_TICKET CHECK(direction IN('Go','Return')) NOT NULL,
  48.     CONSTRAINT PK_TICKET PRIMARY KEY (ticket_id)
  49. );
  50.  
  51. CREATE TABLE T_CUSTOMER (
  52.     customer_id NUMBER(6) NOT NULL,
  53.     last_name VARCHAR2(25) NOT NULL,
  54.     first_name VARCHAR2(25) NOT NULL,
  55.     address VARCHAR2(100) NULL,
  56.     phone VARCHAR2(20) NULL,
  57.     gender CHAR(1) NULL,
  58.     birth_date DATE NOT NULL,
  59.     pass_id NUMBER(6) NULL,
  60.     pass_date DATE NULL,
  61.     CONSTRAINT PK_CUSTOMER PRIMARY KEY (customer_id)
  62. );
  63.  
  64. CREATE TABLE T_EMPLOYEE (
  65.     employee_id NUMBER(6) NOT NULL,
  66.     last_name VARCHAR2(25) NOT NULL,
  67.     first_name VARCHAR2(25) NOT NULL,
  68.     salary NUMBER(8,2) NOT NULL,
  69.     comm_pct NUMBER(2,2) NULL,
  70.     manager_id NUMBER(6) NULL,
  71.     login VARCHAR2(8) NOT NULL,
  72.     pass VARCHAR2(25) NOT NULL,
  73.     CONSTRAINT PK_EMPLOYEE PRIMARY KEY (employee_id)
  74. );
  75.  
  76. CREATE TABLE T_STATION (
  77.     station_id NUMBER(6) NOT NULL,
  78.     city VARCHAR2(25) NOT NULL,
  79.     open_time DATE NOT NULL,
  80.     close_time DATE NOT NULL,
  81.     CONSTRAINT PK_STATION PRIMARY KEY (station_id)
  82. );
  83.  
  84. -- Création d'une vue supplémentaire de la table T_STATION
  85. CREATE VIEW VU_STATION AS
  86.     SELECT station_id, city
  87.     FROM T_STATION;
  88.  
  89. CREATE TABLE T_RESERVATION (
  90.     reservation_id NUMBER(6) NOT NULL,
  91.     employee_id NUMBER(6) NOT NULL,
  92.     creation_date DATE NOT NULL,
  93.     buy_method VARCHAR2(30)
  94.     CONSTRAINT C_C_RESERVATION CHECK(buy_method IN('Credit Card','Cheque','Cash')),
  95.     price NUMBER(8,2) NULL,
  96.     buyer_id NUMBER(6) NOT NULL,
  97.     CONSTRAINT PK_RESERVATION
  98.     PRIMARY KEY (reservation_id)
  99. );
  100.  
  101. CREATE TABLE T_TRAIN (
  102.     train_id NUMBER(6) NOT NULL,
  103.     departure_station_id NUMBER(6) NOT NULL,
  104.     arrival_station_id NUMBER(6) NOT NULL,
  105.     departure_time DATE NOT NULL,
  106.     arrival_time DATE NOT NULL,
  107.     distance NUMBER(6),
  108.     price NUMBER(8,2) NOT NULL,
  109.     CONSTRAINT PK_TRAIN PRIMARY KEY (train_id)
  110. );
  111.  
  112. CREATE TABLE T_WAGON (
  113.     wagon_id NUMBER(6) NOT NULL,
  114.     class_pct NUMBER(2) NULL,
  115.     class_type NUMBER(1)
  116.     CONSTRAINT C_C_WAGON CHECK(class_type IN(1,2)) NOT NULL,
  117.     nb_seat NUMBER(3) NOT NULL,
  118.     CONSTRAINT PK_WAGON PRIMARY KEY (wagon_id)
  119. );
  120.  
  121. CREATE TABLE T_WAGON_TRAIN (
  122.     wag_tr_id NUMBER(6) NOT NULL,
  123.     wagon_id NUMBER(6) NOT NULL,
  124.     train_id NUMBER(6) NOT NULL,
  125.     CONSTRAINT PK_WAGON_TRAIN
  126.     PRIMARY KEY (wag_tr_id)
  127. );
  128.  
  129.  
  130. -- Création des clés étrangères
  131. ALTER TABLE T_CUSTOMER
  132.     ADD CONSTRAINT FK_PASS_CUSTOMER
  133.     FOREIGN KEY (pass_id) REFERENCES T_PASS(pass_id) ON DELETE CASCADE
  134.     DISABLE;
  135.  
  136. ALTER TABLE T_RESERVATION
  137.     ADD CONSTRAINT FK_CUSTOMER_RESERVATION
  138.     FOREIGN KEY (buyer_id) REFERENCES T_CUSTOMER(customer_id) ON DELETE CASCADE
  139.     DISABLE;
  140.  
  141. ALTER TABLE T_RESERVATION
  142.     ADD CONSTRAINT FK_EMPLOYEE_RESERVATION
  143.     FOREIGN KEY (employee_id) REFERENCES T_EMPLOYEE(employee_id) ON DELETE CASCADE
  144.     DISABLE;
  145.  
  146. ALTER TABLE T_EMPLOYEE
  147.     ADD CONSTRAINT FK_EMPLOYEE_EMPLOYEE
  148.     FOREIGN KEY (manager_id) REFERENCES T_EMPLOYEE(employee_id) ON DELETE CASCADE
  149.     DISABLE;
  150.  
  151. ALTER TABLE T_TICKET
  152.     ADD CONSTRAINT FK_CUSTOMER_TICKET
  153.     FOREIGN KEY (customer_id) REFERENCES T_CUSTOMER(customer_id) ON DELETE CASCADE
  154.     DISABLE;
  155.  
  156. ALTER TABLE T_TICKET
  157.     ADD CONSTRAINT FK_RESERVATION_TICKET
  158.     FOREIGN KEY (reservation_id) REFERENCES T_RESERVATION(reservation_id) ON DELETE CASCADE
  159.     DISABLE;
  160.  
  161. ALTER TABLE T_TICKET
  162.     ADD CONSTRAINT FK_WAGON_TRAIN_TICKET
  163.     FOREIGN KEY (wag_tr_id) REFERENCES T_WAGON_TRAIN(wag_tr_id) ON DELETE CASCADE
  164.     DISABLE;
  165.  
  166. ALTER TABLE T_WAGON_TRAIN
  167.     ADD CONSTRAINT FK_WAGON_WAGON_TRAIN
  168.     FOREIGN KEY (wagon_id) REFERENCES T_WAGON(wagon_id) ON DELETE CASCADE
  169.     DISABLE;
  170.  
  171. ALTER TABLE T_WAGON_TRAIN
  172.     ADD CONSTRAINT FK_TRAIN_WAGON_TRAIN
  173.     FOREIGN KEY (train_id) REFERENCES T_TRAIN(train_id) ON DELETE CASCADE
  174.     DISABLE;
  175.  
  176. ALTER TABLE T_TRAIN
  177.     ADD CONSTRAINT FK_STATION_TRAIN_DEPARTURE
  178.     FOREIGN KEY (departure_station_id) REFERENCES T_STATION(station_id) ON DELETE CASCADE
  179.     DISABLE;
  180.  
  181. ALTER TABLE T_TRAIN
  182.     ADD CONSTRAINT FK_STATION_TRAIN_ARRIVAL
  183.     FOREIGN KEY (arrival_station_id) REFERENCES T_STATION(station_id) ON DELETE CASCADE
  184.     DISABLE;
  185.  
  186. -- Création des séquences
  187. CREATE SEQUENCE SEQ_T_PASS;
  188. CREATE SEQUENCE SEQ_T_CUSTOMER;
  189. CREATE SEQUENCE SEQ_T_RESERVATION;
  190. CREATE SEQUENCE SEQ_T_EMPLOYEE;
  191. CREATE SEQUENCE SEQ_T_TICKET;
  192. CREATE SEQUENCE SEQ_T_WAGON;
  193. CREATE SEQUENCE SEQ_T_WAGON_TRAIN;
  194. CREATE SEQUENCE SEQ_T_TRAIN;
  195. CREATE SEQUENCE SEQ_T_STATION;
  196.  
  197. --Insertion des données
  198.  
  199. INSERT INTO t_pass VALUES(seq_t_pass.NEXTVAL,'15-25',50,25,10);
  200. INSERT INTO t_pass VALUES(seq_t_pass.NEXTVAL,'Senior',40,20,20);
  201. INSERT INTO t_pass VALUES(seq_t_pass.NEXTVAL,'Pro',30,15,30);
  202. COMMIT;
  203.  
  204. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,1,1,1,1,'Go');
  205. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,2,1,4,1,'Return');
  206. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,4,6,20,2,'Go');
  207. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,1,25,20,3,'Go');
  208. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,10,25,21,3,'Return');
  209. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,7,23,55,3,'Go');
  210. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,8,57,55,4,'Go');
  211. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,6,72,90,5,'Go');
  212. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,20,72,92,5,'Return');
  213. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,11,65,101,6,'Go');
  214. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,12,68,134,7,'Go');
  215. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,17,60,9,8,'Go');
  216. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,19,60,15,8,'Return');
  217. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,16,77,9,8,'Go');
  218. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,14,67,9,8,'Go');
  219. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,13,74,9,8,'Go');
  220. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,9,61,9,8,'Go');
  221. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,1,80,25,9,'Go');
  222. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,2,67,35,10,'Go');
  223. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,5,73,36,11,'Go');
  224. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,5,73,41,11,'Return');
  225. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,10,62,52,12,'Go');
  226. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,15,46,68,13,'Go');
  227. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,18,63,109,14,'Go');
  228. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,19,63,113,14,'Return');
  229. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,3,43,118,15,'Go');
  230. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,10,43,122,15,'Return');
  231. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,16,47,118,15,'Go');
  232. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,17,47,122,15,'Return');
  233. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,10,18,24,16,'Go');
  234. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,3,33,84,17,'Go');
  235. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,10,33,88,17,'Return');
  236. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,8,43,115,18,'Go');
  237. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,13,43,116,18,'Return');
  238. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,14,53,114,18,'Go');
  239. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,6,53,116,18,'Return');
  240. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,14,66,133,19,'Go');
  241. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,16,59,2,20,'Go');
  242. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,4,30,22,21,'Go');
  243. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,6,39,44,22,'Go');
  244. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,9,46,62,23,'Go');
  245. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,10,46,63,23,'Return');
  246. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,17,75,78,23,'Go');
  247. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,15,53,97,24,'Go');
  248. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,2,33,98,25,'Go');
  249. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,3,45,105,26,'Go');
  250. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,14,52,126,27,'Go');
  251. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,7,52,127,27,'Return');
  252. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,13,59,1,28,'Go');
  253. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,14,59,5,28,'Return');
  254. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,7,37,94,29,'Go');
  255. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,7,41,3,30,'Go');
  256. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,18,41,7,30,'Return');
  257. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,3,41,53,30,'Go');
  258. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,10,41,55,30,'Return');
  259. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,16,50,1,31,'Go');
  260. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,8,50,8,31,'Return');
  261. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,8,72,13,31,'Go');
  262. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,17,72,17,31,'Return');
  263. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,17,34,37,32,'Go');
  264. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,14,39,134,33,'Go');
  265. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,18,69,10,34,'Go');
  266. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,16,69,16,34,'Return');
  267. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,16,15,33,35,'Go');
  268. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,13,27,59,36,'Go');
  269. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,15,54,8,37,'Go');
  270. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,19,77,8,38,'Go');
  271. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,17,49,12,39,'Go');
  272. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,15,49,17,39,'Return');
  273. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,12,68,127,40,'Go');
  274. INSERT INTO t_ticket VALUES(seq_t_ticket.NEXTVAL,6,66,130,41,'Go');
  275. COMMIT;
  276.  
  277. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Fleming','Steve','59 Faubourg Saint Honoré - F-75016 Paris','01.94.59.91.81','H',TO_DATE('07/07/1988', 'dd/mm/yyyy'),NULL,NULL);
  278. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Wayne','Williams','28 rue La Boétie - F-75016 Paris','01.24.72.19.75','H',TO_DATE('07/01/1992', 'dd/mm/yyyy'),NULL,NULL);
  279. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Richardson','Lauren','94 rue Nationale - F-75004 Paris','01.96.88.39.63','F',TO_DATE('21/02/1988', 'dd/mm/yyyy'),NULL,NULL);
  280. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Clark','Paul','95 Place de la Madeleine - F-75009 Paris','01.51.53.70.45','H',TO_DATE('20/06/1992', 'dd/mm/yyyy'),1,TO_DATE('09/01/2019','dd/mm/yyyy'));
  281. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Reynolds','Philip','05 Faubourg Saint Honoré - F-75016 Paris','01.05.05.05.05','H',TO_DATE('12/03/1991', 'dd/mm/yyyy'),NULL,NULL);
  282. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Healy','Stacy','06 Faubourg Saint Honoré - F-75016 Paris','01.06.06.06.06','F',TO_DATE('16/10/1992', 'dd/mm/yyyy'),NULL,NULL);
  283. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Novak','Craig','07 Faubourg Saint Honoré - F-75016 Paris','01.07.07.07.07','H',TO_DATE('18/02/1990', 'dd/mm/yyyy'),NULL,NULL);
  284. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Barnes','Ted','08 Faubourg Saint Honoré - F-75016 Paris','01.08.08.08.08','H',TO_DATE('05/03/1993', 'dd/mm/yyyy'),2,TO_DATE('25/02/2019','dd/mm/yyyy'));
  285. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Oswald','Georges','09 Faubourg Saint Honoré - F-75016 Paris','01.09.09.09.09','H',TO_DATE('15/10/1992', 'dd/mm/yyyy'),NULL,NULL);
  286. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Collins','Ben','10 Faubourg Saint Honoré - F-75016 Paris','01.10.10.10.10','H',TO_DATE('27/03/1992', 'dd/mm/yyyy'),3,TO_DATE('17/03/2019','dd/mm/yyyy'));
  287. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Hamilton','Melvin','11 Faubourg Saint Honoré - F-75016 Paris','01.11.11.11.11','H',TO_DATE('18/03/1994', 'dd/mm/yyyy'),3,TO_DATE('12/04/2019','dd/mm/yyyy'));
  288. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Hancock','Marcia','12 Faubourg Saint Honoré - F-75016 Paris','01.12.12.12.12','F',TO_DATE('15/07/1992', 'dd/mm/yyyy'),2,TO_DATE('23/05/2018','dd/mm/yyyy'));
  289. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Dawn','Lane','13 Faubourg Saint Honoré - F-75016 Paris','01.13.13.13.13','F',TO_DATE('05/08/1992', 'dd/mm/yyyy'),NULL,NULL);
  290. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Wayne','Leonard','14 Faubourg Saint Honoré - F-75016 Paris','01.14.14.14.14','H',TO_DATE('09/03/1991', 'dd/mm/yyyy'),NULL,NULL);
  291. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Nielsen','Raph','15 Faubourg Saint Honoré - F-75016 Paris','01.15.15.15.15','H',TO_DATE('08/10/1995', 'dd/mm/yyyy'),1,TO_DATE('23/03/2019','dd/mm/yyyy'));
  292. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Alen','Doug','16 Faubourg Saint Honoré - F-75016 Paris','01.16.16.16.16','H',TO_DATE('02/06/1992', 'dd/mm/yyyy'),2,TO_DATE('25/06/2018','dd/mm/yyyy'));
  293. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Patterson','Philip','17 Faubourg Saint Honoré - F-75016 Paris','01.17.17.17.17','H',TO_DATE('16/11/1989', 'dd/mm/yyyy'),NULL,NULL);
  294. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Rice','Joe','18 Faubourg Saint Honoré - F-75016 Paris','01.18.18.18.18','H',TO_DATE('05/07/1991', 'dd/mm/yyyy'),NULL,NULL);
  295. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Lang','Wayne','19 Faubourg Saint Honoré - F-75016 Paris','01.19.19.19.19','H',TO_DATE('21/02/1991', 'dd/mm/yyyy'),2,TO_DATE('02/07/2018','dd/mm/yyyy'));
  296. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Larson','Arthur','20 Faubourg Saint Honoré - F-75016 Paris','01.20.20.20.20','H',TO_DATE('11/03/1988', 'dd/mm/yyyy'),NULL,NULL);
  297. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Nielsen','Melvin','21 Faubourg Saint Honoré - F-75016 Paris','01.21.21.21.21','H',TO_DATE('26/09/1994', 'dd/mm/yyyy'),2,TO_DATE('18/08/2018','dd/mm/yyyy'));
  298. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Miler','Victor','22 Faubourg Saint Honoré - F-75016 Paris','01.22.22.22.22','H',TO_DATE('10/07/1989', 'dd/mm/yyyy'),NULL,NULL);
  299. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Herman','Smith','23 Faubourg Saint Honoré - F-75016 Paris','01.23.23.23.23','H',TO_DATE('26/10/1992', 'dd/mm/yyyy'),NULL,NULL);
  300. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Steinbach','Barbra','24 Faubourg Saint Honoré - F-75016 Paris','01.24.24.24.24','F',TO_DATE('03/01/1993', 'dd/mm/yyyy'),3,TO_DATE('21/09/2018','dd/mm/yyyy'));
  301. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Gordon','Rosemary','25 Faubourg Saint Honoré - F-75016 Paris','01.25.25.25.25','F',TO_DATE('03/06/1990', 'dd/mm/yyyy'),NULL,NULL);
  302. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Erickson','Lou','26 Faubourg Saint Honoré - F-75016 Paris','01.26.26.26.26','H',TO_DATE('23/08/1991', 'dd/mm/yyyy'),3,TO_DATE('02/03/2019','dd/mm/yyyy'));
  303. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Dalton','Vance','27 Faubourg Saint Honoré - F-75016 Paris','01.27.27.27.27','H',TO_DATE('21/03/1988', 'dd/mm/yyyy'),NULL,NULL);
  304. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Cooper','Clarck','28 Faubourg Saint Honoré - F-75016 Paris','01.28.28.28.28','H',TO_DATE('17/06/1994', 'dd/mm/yyyy'),2,TO_DATE('04/11/2018','dd/mm/yyyy'));
  305. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Bauer','John','29 Faubourg Saint Honoré - F-75016 Paris','01.29.29.29.29','H',TO_DATE('26/05/1992', 'dd/mm/yyyy'),NULL,NULL);
  306. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Harris','Brandy','30 Faubourg Saint Honoré - F-75016 Paris','01.30.30.30.30','F',TO_DATE('14/08/1989', 'dd/mm/yyyy'),NULL,NULL);
  307. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Ferguson','Angie','31 Faubourg Saint Honoré - F-75016 Paris','01.31.31.31.31','F',TO_DATE('12/05/1988', 'dd/mm/yyyy'),NULL,NULL);
  308. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Cunningham','Dennis','32 Faubourg Saint Honoré - F-75016 Paris','01.32.32.32.32','H',TO_DATE('01/08/1992', 'dd/mm/yyyy'),2,TO_DATE('10/07/2018','dd/mm/yyyy'));
  309. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Cunningham','Charles','33 Faubourg Saint Honoré - F-75016 Paris','01.33.33.33.33','H',TO_DATE('08/02/1992', 'dd/mm/yyyy'),NULL,NULL);
  310. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Fraser','Thomas','34 Faubourg Saint Honoré - F-75016 Paris','01.34.34.34.34','H',TO_DATE('03/08/1988', 'dd/mm/yyyy'),NULL,NULL);
  311. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Graham','Linda','35 Faubourg Saint Honoré - F-75016 Paris','01.35.35.35.35','F',TO_DATE('12/02/1991', 'dd/mm/yyyy'),1,TO_DATE('23/01/2018','dd/mm/yyyy'));
  312. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Barnes','Katherine','36 Faubourg Saint Honoré - F-75016 Paris','01.36.36.36.36','F',TO_DATE('02/08/1991', 'dd/mm/yyyy'),NULL,NULL);
  313. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Michaels','Timothy','37 Faubourg Saint Honoré - F-75016 Paris','01.37.37.37.37','H',TO_DATE('20/10/1992', 'dd/mm/yyyy'),3,TO_DATE('14/02/2018','dd/mm/yyyy'));
  314. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Sattler','Jack','38 Faubourg Saint Honoré - F-75016 Paris','01.38.38.38.38','H',TO_DATE('15/08/1992', 'dd/mm/yyyy'),NULL,NULL);
  315. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Warren','Paul','39 Faubourg Saint Honoré - F-75016 Paris','01.39.39.39.39','H',TO_DATE('08/04/1992', 'dd/mm/yyyy'),2,TO_DATE('11/03/2019','dd/mm/yyyy'));
  316. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Richards','Paul','40 Faubourg Saint Honoré - F-75016 Paris','01.40.40.40.40','H',TO_DATE('07/06/1990', 'dd/mm/yyyy'),NULL,NULL);
  317. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Landers','Robert','41 Faubourg Saint Honoré - F-75016 Paris','01.41.41.41.41','H',TO_DATE('17/11/1991', 'dd/mm/yyyy'),NULL,NULL);
  318. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Powel','Tom','42 Faubourg Saint Honoré - F-75016 Paris','01.42.42.42.42','H',TO_DATE('24/06/1992', 'dd/mm/yyyy'),3,TO_DATE('07/04/2018','dd/mm/yyyy'));
  319. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Holmes','Martin','43 Faubourg Saint Honoré - F-75016 Paris','01.43.43.43.43','H',TO_DATE('10/08/1988', 'dd/mm/yyyy'),NULL,NULL);
  320. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Williams','Megan','44 Faubourg Saint Honoré - F-75016 Paris','01.44.44.44.44','F',TO_DATE('22/10/1989', 'dd/mm/yyyy'),NULL,NULL);
  321. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Tucker','Gerard','45 Faubourg Saint Honoré - F-75016 Paris','01.45.45.45.45','H',TO_DATE('14/06/1994', 'dd/mm/yyyy'),1,TO_DATE('02/05/2019','dd/mm/yyyy'));
  322. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Reynolds','Samantha','46 Faubourg Saint Honoré - F-75016 Paris','01.46.46.46.46','F',TO_DATE('27/05/1995', 'dd/mm/yyyy'),3,TO_DATE('14/06/2018','dd/mm/yyyy'));
  323. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Petersen','Melody','47 Faubourg Saint Honoré - F-75016 Paris','01.47.47.47.47','F',TO_DATE('23/05/1993', 'dd/mm/yyyy'),2,TO_DATE('08/07/2018','dd/mm/yyyy'));
  324. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Fraser','Faun','48 Faubourg Saint Honoré - F-75016 Paris','01.48.48.48.48','F',TO_DATE('23/11/1990', 'dd/mm/yyyy'),NULL,NULL);
  325. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Jacobs','Tarryn','49 Faubourg Saint Honoré - F-75016 Paris','01.49.49.49.49','F',TO_DATE('13/06/1992', 'dd/mm/yyyy'),2,TO_DATE('15/08/2018','dd/mm/yyyy'));
  326. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Parker','Steve','50 Faubourg Saint Honoré - F-75016 Paris','01.50.50.50.50','H',TO_DATE('01/08/1992', 'dd/mm/yyyy'),2,TO_DATE('13/09/2018','dd/mm/yyyy'));
  327. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'White','Elliott','51 Faubourg Saint Honoré - F-75016 Paris','01.51.51.51.51','H',TO_DATE('23/11/1991', 'dd/mm/yyyy'),3,TO_DATE('12/03/2019','dd/mm/yyyy'));
  328. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Miller','Alex','52 Faubourg Saint Honoré - F-75016 Paris','01.52.52.52.52','H',TO_DATE('06/02/1990', 'dd/mm/yyyy'),NULL,NULL);
  329. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Ross','Lou','53 Faubourg Saint Honoré - F-75016 Paris','01.53.53.53.53','H',TO_DATE('13/07/1991', 'dd/mm/yyyy'),1,TO_DATE('04/11/2018','dd/mm/yyyy'));
  330. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Lyons','Gordons','54 Faubourg Saint Honoré - F-75016 Paris','01.54.54.54.54','H',TO_DATE('03/10/1992', 'dd/mm/yyyy'),3,TO_DATE('01/01/2018','dd/mm/yyyy'));
  331. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Hamilton','Dory','55 Faubourg Saint Honoré - F-75016 Paris','01.55.55.55.55','F',TO_DATE('13/10/1988', 'dd/mm/yyyy'),NULL,NULL);
  332. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Sanders','Laurie','56 Faubourg Saint Honoré - F-75016 Paris','01.56.56.56.56','F',TO_DATE('05/02/1992', 'dd/mm/yyyy'),1,TO_DATE('15/02/2019','dd/mm/yyyy'));
  333. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Maugard','Gregory','57 Faubourg Saint Honoré - F-75016 Paris','01.57.57.57.57','H',TO_DATE('02/02/1992', 'dd/mm/yyyy'),NULL,NULL);
  334. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Smith','Kevin','58 Faubourg Saint Honoré - F-75016 Paris','01.58.58.58.58','H',TO_DATE('07/05/1990', 'dd/mm/yyyy'),NULL,NULL);
  335. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Barnes','Bill','59 Faubourg Saint Honoré - F-75016 Paris','01.59.59.59.59','H',TO_DATE('13/05/1992', 'dd/mm/yyyy'),NULL,NULL);
  336. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Novak','Jessie','60 Faubourg Saint Honoré - F-75016 Paris','01.60.60.60.60','F',TO_DATE('03/01/1991', 'dd/mm/yyyy'),NULL,NULL);
  337. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Philips','Rich','61 Faubourg Saint Honoré - F-75016 Paris','01.61.61.61.61','H',TO_DATE('14/02/1991', 'dd/mm/yyyy'),2,TO_DATE('15/03/2019','dd/mm/yyyy'));
  338. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'McDaniels','Wayne','62 Faubourg Saint Honoré - F-75016 Paris','01.62.62.62.62','H',TO_DATE('27/10/1988', 'dd/mm/yyyy'),NULL,NULL);
  339. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Morris','Tim','63 Faubourg Saint Honoré - F-75016 Paris','01.63.63.63.63','H',TO_DATE('25/01/1988', 'dd/mm/yyyy'),NULL,NULL);
  340. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Albert','Thomas','64 Faubourg Saint Honoré - F-75016 Paris','01.64.64.64.64','H',TO_DATE('04/01/1992', 'dd/mm/yyyy'),2,TO_DATE('09/04/2019','dd/mm/yyyy'));
  341. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Burton','Albert','65 Faubourg Saint Honoré - F-75016 Paris','01.65.65.65.65','H',TO_DATE('10/09/1990', 'dd/mm/yyyy'),NULL,NULL);
  342. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Quinn','Rosemary','66 Faubourg Saint Honoré - F-75016 Paris','01.66.66.66.66','F',TO_DATE('21/08/1992', 'dd/mm/yyyy'),2,TO_DATE('21/05/2018','dd/mm/yyyy'));
  343. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Hess','Katherine','67 Faubourg Saint Honoré - F-75016 Paris','01.67.67.67.67','F',TO_DATE('02/05/1989', 'dd/mm/yyyy'),NULL,NULL);
  344. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Landers','Philip','68 Faubourg Saint Honoré - F-75016 Paris','01.68.68.68.68','H',TO_DATE('27/11/1993', 'dd/mm/yyyy'),1,TO_DATE('03/06/2018','dd/mm/yyyy'));
  345. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Harris','Joe','69 Faubourg Saint Honoré - F-75016 Paris','01.69.69.69.69','H',TO_DATE('16/09/1992', 'dd/mm/yyyy'),NULL,NULL);
  346. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Hendrix','Charles','70 Faubourg Saint Honoré - F-75016 Paris','01.70.70.70.70','H',TO_DATE('11/06/1991', 'dd/mm/yyyy'),3,TO_DATE('11/07/2018','dd/mm/yyyy'));
  347. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'McDaniels','Stacy','71 Faubourg Saint Honoré - F-75016 Paris','01.71.71.71.71','F',TO_DATE('03/06/1992', 'dd/mm/yyyy'),NULL,NULL);
  348. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Petersen','David','72 Faubourg Saint Honoré - F-75016 Paris','01.72.72.72.72','H',TO_DATE('19/09/1988', 'dd/mm/yyyy'),NULL,NULL);
  349. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Erickson','Harvey','73 Faubourg Saint Honoré - F-75016 Paris','01.73.73.73.73','H',TO_DATE('05/04/1992', 'dd/mm/yyyy'),2,TO_DATE('02/08/2018','dd/mm/yyyy'));
  350. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Erickson','Leonard','74 Faubourg Saint Honoré - F-75016 Paris','01.74.74.74.74','H',TO_DATE('09/08/1991', 'dd/mm/yyyy'),NULL,NULL);
  351. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Fields','Romain','75 Faubourg Saint Honoré - F-75016 Paris','01.75.75.75.75','H',TO_DATE('07/10/1992', 'dd/mm/yyyy'),NULL,NULL);
  352. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Barnes','Luann','76 Faubourg Saint Honoré - F-75016 Paris','01.76.76.76.76','H',TO_DATE('04/10/1995', 'dd/mm/yyyy'),1,TO_DATE('24/09/2018','dd/mm/yyyy'));
  353. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Burton','Whitney','77 Faubourg Saint Honoré - F-75016 Paris','01.77.77.77.77','F',TO_DATE('03/04/1991', 'dd/mm/yyyy'),3,TO_DATE('16/03/2019','dd/mm/yyyy'));
  354. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Oswald','Ty','78 Faubourg Saint Honoré - F-75016 Paris','01.78.78.78.78','H',TO_DATE('24/10/1992', 'dd/mm/yyyy'),NULL,NULL);
  355. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Gordon','Roy','79 Faubourg Saint Honoré - F-75016 Paris','01.79.79.79.79','H',TO_DATE('06/01/1988', 'dd/mm/yyyy'),NULL,NULL);
  356. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Brooke','Morgan','80 Faubourg Saint Honoré - F-75016 Paris','01.80.80.80.80','F',TO_DATE('21/10/1993', 'dd/mm/yyyy'),1,TO_DATE('04/11/2018','dd/mm/yyyy'));
  357. INSERT INTO t_customer VALUES(seq_t_customer.NEXTVAL,'Herman','Tom','81 Faubourg Saint Honoré - F-75016 Paris','01.81.81.81.81','H',TO_DATE('11/06/1992', 'dd/mm/yyyy'),NULL,NULL);
  358. COMMIT;
  359.  
  360. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Gladu','Erwan',20000,NULL,NULL,'gladu_e','aduwan');
  361. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Desnoyer','Jerome',15000,NULL,1,'desnoy_j','yerome');
  362. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Coudert','Reda',9500,.35,4,'couder_r','erteda');
  363. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Roy','Thibault',15150,NULL,1,'roy_t','royult');
  364. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Langlois','Arnaud',10100,.2,7,'langlo_a','oisaud');
  365. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Gousse','Kevin',8000,NULL,10,'gousse_k','ssevin');
  366. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Ayot','Davina',15200,NULL,1,'ayot_d','yotina');
  367. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Mothe','Francois',7550,.3,4,'mothe_f','theier');
  368. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Poissonnier','Maxime',12500,.25,7,'poisso_m','ierime');
  369. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Saurel','André',14850,NULL,1,'saurel_a','relrei');
  370. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Patenaude','Etienne',9550,.2,10,'patena_e','udenne');
  371. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Faubert','Mathieu',7550,NULL,10,'fauber_m','ertieu');
  372. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Monrency','Yoan',8500,.1,4,'monren_y','ncyoan');
  373. INSERT INTO t_employee VALUES(seq_t_employee.NEXTVAL,'Chalut','Pierre',7000,NULL,7,'chalut_p','lutnry');
  374. COMMIT;
  375.  
  376. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Bordeaux',TO_DATE('06:30','hh24:mi'),TO_DATE('22:00','hh24:mi'));
  377. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Brest',TO_DATE('06:45','hh24:mi'),TO_DATE('21:45','hh24:mi'));
  378. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Calais',TO_DATE('06:15','hh24:mi'),TO_DATE('23:40','hh24:mi'));
  379. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Clermont-Ferrand',TO_DATE('08:00','hh24:mi'),TO_DATE('20:30','hh24:mi'));
  380. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Dijon',TO_DATE('08:15','hh24:mi'),TO_DATE('23:15','hh24:mi'));
  381. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Grenoble',TO_DATE('08:30','hh24:mi'),TO_DATE('20:00','hh24:mi'));
  382. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Le Havre',TO_DATE('07:45','hh24:mi'),TO_DATE('22:15','hh24:mi'));
  383. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Lyon',TO_DATE('06:45','hh24:mi'),TO_DATE('19:45','hh24:mi'));
  384. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Macon',TO_DATE('06:15','hh24:mi'),TO_DATE('23:15','hh24:mi'));
  385. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Marseille',TO_DATE('07:00','hh24:mi'),TO_DATE('22:45','hh24:mi'));
  386. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Montpellier',TO_DATE('06:30','hh24:mi'),TO_DATE('23:00','hh24:mi'));
  387. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Mulhouse',TO_DATE('07:00','hh24:mi'),TO_DATE('22:00','hh24:mi'));
  388. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Nantes',TO_DATE('06:30','hh24:mi'),TO_DATE('23:00','hh24:mi'));
  389. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Nice',TO_DATE('07:15','hh24:mi'),TO_DATE('22:30','hh24:mi'));
  390. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Nimes',TO_DATE('08:00','hh24:mi'),TO_DATE('21:30','hh24:mi'));
  391. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Paris',TO_DATE('06:15','hh24:mi'),TO_DATE('23:45','hh24:mi'));
  392. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Saint-Malo',TO_DATE('09:00','hh24:mi'),TO_DATE('22:45','hh24:mi'));
  393. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Strasbourg',TO_DATE('06:15','hh24:mi'),TO_DATE('21:00','hh24:mi'));
  394. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Toulouse',TO_DATE('07:45','hh24:mi'),TO_DATE('22:30','hh24:mi'));
  395. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Troyes',TO_DATE('06:30','hh24:mi'),TO_DATE('23:30','hh24:mi'));
  396. INSERT INTO t_station VALUES(seq_t_station.NEXTVAL,'Valenciennes',TO_DATE('07:00','hh24:mi'),TO_DATE('22:00','hh24:mi'));
  397. COMMIT;
  398.  
  399. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,3,TO_DATE('05/11/2018','dd/mm/yyyy'),'Credit Card',289.2,1);
  400. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,7,TO_DATE('03/11/2018','dd/mm/yyyy'),'Cheque',165.5,6);
  401. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,4,TO_DATE('29/03/2019','dd/mm/yyyy'),'Credit Card',588.4,23);
  402. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,7,TO_DATE('25/03/2019','dd/mm/yyyy'),'Cash',257.4,57);
  403. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,7,TO_DATE('02/11/2018','dd/mm/yyyy'),'Credit Card',175,72);
  404. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,7,TO_DATE('23/03/2019','dd/mm/yyyy'),'Cheque',225,65);
  405. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,7,TO_DATE('15/03/2019','dd/mm/yyyy'),'Cheque',37.12,68);
  406. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,3,TO_DATE('05/11/2018','dd/mm/yyyy'),'Credit Card',948.64,60);
  407. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,3,TO_DATE('05/11/2018','dd/mm/yyyy'),'Cheque',57,80);
  408. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,11,TO_DATE('05/11/2018','dd/mm/yyyy'),'Cheque',202.5,67);
  409. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,11,TO_DATE('05/11/2018','dd/mm/yyyy'),'Credit Card',202.5,73);
  410. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,12,TO_DATE('05/11/2018','dd/mm/yyyy'),'Credit Card',214.5,62);
  411. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,13,TO_DATE('08/11/2018','dd/mm/yyyy'),'',NULL,46);
  412. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,13,TO_DATE('08/11/2018','dd/mm/yyyy'),'Credit Card',291.6,63);
  413. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,13,TO_DATE('01/11/2018','dd/mm/yyyy'),'Cheque',376.8,43);
  414. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,2,TO_DATE('15/03/2019','dd/mm/yyyy'),'Credit Card',114,18);
  415. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,2,TO_DATE('12/03/2019','dd/mm/yyyy'),'Credit Card',400,33);
  416. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,2,TO_DATE('13/03/2019','dd/mm/yyyy'),'',NULL,43);
  417. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,9,TO_DATE('10/03/2019','dd/mm/yyyy'),'Credit Card',33,66);
  418. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,9,TO_DATE('07/03/2019','dd/mm/yyyy'),'Cheque',120.5,81);
  419. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,9,TO_DATE('07/01/2019','dd/mm/yyyy'),'Cheque',165.5,30);
  420. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,9,TO_DATE('10/01/2019','dd/mm/yyyy'),'Credit Card',121.5,39);
  421. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,9,TO_DATE('11/11/2018','dd/mm/yyyy'),'',NULL,46);
  422. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,4,TO_DATE('07/11/2018','dd/mm/yyyy'),'Credit Card',35.62,53);
  423. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,4,TO_DATE('08/11/2018','dd/mm/yyyy'),'Cheque',71.25,33);
  424. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,10,TO_DATE('08/11/2018','dd/mm/yyyy'),'Credit Card',39.5,45);
  425. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,10,TO_DATE('03/12/2018','dd/mm/yyyy'),'Credit Card',66,52);
  426. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,10,TO_DATE('10/12/2018','dd/mm/yyyy'),'Credit Card',289.2,77);
  427. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,10,TO_DATE('12/11/2018','dd/mm/yyyy'),'Credit Card',61.25,37);
  428. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,10,TO_DATE('12/11/2018','dd/mm/yyyy'),'Cheque',712.9,41);
  429. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,5,TO_DATE('01/11/2018','dd/mm/yyyy'),'',NULL,19);
  430. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,5,TO_DATE('27/03/2019','dd/mm/yyyy'),'Cheque',168.75,34);
  431. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,5,TO_DATE('26/03/2019','dd/mm/yyyy'),'Cash',39.6,39);
  432. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,6,TO_DATE('05/11/2018','dd/mm/yyyy'),'Cheque',308,69);
  433. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,2,TO_DATE('15/11/2018','dd/mm/yyyy'),'Credit Card',31.5,15);
  434. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,2,TO_DATE('15/11/2018','dd/mm/yyyy'),'Credit Card',214.5,27);
  435. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,2,TO_DATE('16/11/2018','dd/mm/yyyy'),'Cash',84.35,54);
  436. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,12,TO_DATE('03/11/2018','dd/mm/yyyy'),'Credit Card',84.35,77);
  437. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,12,TO_DATE('20/03/2019','dd/mm/yyyy'),'Cheque',184.8,49);
  438. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,12,TO_DATE('28/03/2019','dd/mm/yyyy'),'Credit Card',15,68);
  439. INSERT INTO t_reservation VALUES(seq_t_reservation.NEXTVAL,14,TO_DATE('26/03/2019','dd/mm/yyyy'),'Credit Card',24.75,66);
  440. COMMIT;
  441.  
  442. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,16,1,TO_DATE('21/01/2019 09:00','dd/mm/yyyy hh24:mi'),TO_DATE('21/01/2019 12:00','dd/mm/yyyy hh24:mi'),482,120.5);
  443. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,1,16,TO_DATE('21/01/2019 14:30','dd/mm/yyyy hh24:mi'),TO_DATE('21/01/2019 17:30','dd/mm/yyyy hh24:mi'),482,120.5);
  444. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,16,10,TO_DATE('22/01/2019 12:00','dd/mm/yyyy hh24:mi'),TO_DATE('22/01/2019 15:15','dd/mm/yyyy hh24:mi'),616,154);
  445. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,10,16,TO_DATE('22/01/2019 18:00','dd/mm/yyyy hh24:mi'),TO_DATE('22/01/2019 21:15','dd/mm/yyyy hh24:mi'),616,154);
  446. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,10,13,TO_DATE('21/01/2019 07:15','dd/mm/yyyy hh24:mi'),TO_DATE('21/01/2019 11:00','dd/mm/yyyy hh24:mi'),662,165.5);
  447. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,13,10,TO_DATE('21/01/2019 18:15','dd/mm/yyyy hh24:mi'),TO_DATE('21/01/2019 22:00','dd/mm/yyyy hh24:mi'),662,165.5);
  448. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,8,19,TO_DATE('22/01/2019 09:00','dd/mm/yyyy hh24:mi'),TO_DATE('22/01/2019 11:00','dd/mm/yyyy hh24:mi'),380,95);
  449. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,19,8,TO_DATE('22/01/2019 17:00','dd/mm/yyyy hh24:mi'),TO_DATE('22/01/2019 19:00','dd/mm/yyyy hh24:mi'),380,95);
  450. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,13,8,TO_DATE('23/01/2019 11:00','dd/mm/yyyy hh24:mi'),TO_DATE('23/01/2019 12:30','dd/mm/yyyy hh24:mi'),252,63);
  451. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,8,13,TO_DATE('24/01/2019 09:30','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 11:30','dd/mm/yyyy hh24:mi'),252,63);
  452. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,14,16,TO_DATE('24/01/2019 08:00','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 11:35','dd/mm/yyyy hh24:mi'),675,168.75);
  453. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,16,14,TO_DATE('24/01/2019 16:30','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 20:05','dd/mm/yyyy hh24:mi'),675,168.75);
  454. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,10,15,TO_DATE('23/01/2019 07:40','dd/mm/yyyy hh24:mi'),TO_DATE('23/01/2019 08:10','dd/mm/yyyy hh24:mi'),77,19.25);
  455. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,15,10,TO_DATE('24/01/2019 19:30','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 20:00','dd/mm/yyyy hh24:mi'),77,19.25);
  456. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,18,2,TO_DATE('24/01/2019 11:40','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 16:10','dd/mm/yyyy hh24:mi'),858,214.5);
  457. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,2,18,TO_DATE('24/01/2019 16:20','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 20:20','dd/mm/yyyy hh24:mi'),858,214.5);
  458. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,2,1,TO_DATE('25/01/2019 07:00','dd/mm/yyyy hh24:mi'),TO_DATE('25/01/2019 09:30','dd/mm/yyyy hh24:mi'),511,127.75);
  459. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,1,2,TO_DATE('25/01/2019 18:30','dd/mm/yyyy hh24:mi'),TO_DATE('25/01/2019 21:00','dd/mm/yyyy hh24:mi'),511,127.75);
  460. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,9,1,TO_DATE('24/01/2019 10:00','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 12:10','dd/mm/yyyy hh24:mi'),425,106.25);
  461. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,1,9,TO_DATE('24/01/2019 15:00','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 17:10','dd/mm/yyyy hh24:mi'),425,106.25);
  462. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,19,4,TO_DATE('25/01/2019 12:30','dd/mm/yyyy hh24:mi'),TO_DATE('25/01/2019 14:00','dd/mm/yyyy hh24:mi'),275,68.75);
  463. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,4,19,TO_DATE('25/01/2019 16:30','dd/mm/yyyy hh24:mi'),TO_DATE('25/01/2019 18:00','dd/mm/yyyy hh24:mi'),275,68.75);
  464. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,17,15,TO_DATE('14/01/2019 09:00','dd/mm/yyyy hh24:mi'),TO_DATE('14/01/2019 13:00','dd/mm/yyyy hh24:mi'),800,200);
  465. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,15,17,TO_DATE('14/01/2019 16:00','dd/mm/yyyy hh24:mi'),TO_DATE('14/01/2019 20:00','dd/mm/yyyy hh24:mi'),800,200);
  466. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,17,16,TO_DATE('16/01/2019 10:00','dd/mm/yyyy hh24:mi'),TO_DATE('16/01/2019 12:00','dd/mm/yyyy hh24:mi'),350,87.5);
  467. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,16,17,TO_DATE('16/01/2019 15:30','dd/mm/yyyy hh24:mi'),TO_DATE('16/01/2019 17:30','dd/mm/yyyy hh24:mi'),350,87.5);
  468. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,11,14,TO_DATE('18/01/2019 09:30','dd/mm/yyyy hh24:mi'),TO_DATE('18/01/2019 11:10','dd/mm/yyyy hh24:mi'),285,71.25);
  469. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,14,11,TO_DATE('18/01/2019 19:00','dd/mm/yyyy hh24:mi'),TO_DATE('18/01/2019 20:40','dd/mm/yyyy hh24:mi'),285,71.25);
  470. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,12,2,TO_DATE('20/01/2019 10:00','dd/mm/yyyy hh24:mi'),TO_DATE('20/01/2019 14:30','dd/mm/yyyy hh24:mi'),900,225);
  471. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,2,12,TO_DATE('20/01/2019 15:00','dd/mm/yyyy hh24:mi'),TO_DATE('20/01/2019 19:30','dd/mm/yyyy hh24:mi'),900,225);
  472. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,20,8,TO_DATE('22/01/2019 12:00','dd/mm/yyyy hh24:mi'),TO_DATE('22/01/2019 14:00','dd/mm/yyyy hh24:mi'),316,79);
  473. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,8,20,TO_DATE('22/01/2019 16:00','dd/mm/yyyy hh24:mi'),TO_DATE('22/01/2019 18:00','dd/mm/yyyy hh24:mi'),316,79);
  474. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,21,18,TO_DATE('24/01/2019 11:10','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 13:50','dd/mm/yyyy hh24:mi'),486,121.5);
  475. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,18,21,TO_DATE('24/01/2019 17:00','dd/mm/yyyy hh24:mi'),TO_DATE('24/01/2019 19:40','dd/mm/yyyy hh24:mi'),486,121.5);
  476. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,3,16,TO_DATE('26/01/2019 11:00','dd/mm/yyyy hh24:mi'),TO_DATE('26/01/2019 12:45','dd/mm/yyyy hh24:mi'),290,72.5);
  477. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,16,3,TO_DATE('27/01/2019 13:00','dd/mm/yyyy hh24:mi'),TO_DATE('27/01/2019 14:45','dd/mm/yyyy hh24:mi'),290,72.5);
  478. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,5,21,TO_DATE('28/01/2019 09:00','dd/mm/yyyy hh24:mi'),TO_DATE('28/01/2019 11:35','dd/mm/yyyy hh24:mi'),471,117.75);
  479. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,21,5,TO_DATE('28/01/2019 14:00','dd/mm/yyyy hh24:mi'),TO_DATE('28/01/2019 16:35','dd/mm/yyyy hh24:mi'),471,117.75);
  480. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,6,9,TO_DATE('30/01/2019 08:30','dd/mm/yyyy hh24:mi'),TO_DATE('30/01/2019 09:10','dd/mm/yyyy hh24:mi'),120,30);
  481. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,9,6,TO_DATE('30/01/2019 10:10','dd/mm/yyyy hh24:mi'),TO_DATE('30/01/2019 10:50','dd/mm/yyyy hh24:mi'),120,30);
  482. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,7,16,TO_DATE('01/02/2019 12:10','dd/mm/yyyy hh24:mi'),TO_DATE('01/02/2019 13:00','dd/mm/yyyy hh24:mi'),165,41.25);
  483. INSERT INTO t_train VALUES(seq_t_train.NEXTVAL,16,7,TO_DATE('02/02/2019 19:10','dd/mm/yyyy hh24:mi'),TO_DATE('02/02/2019 20:00','dd/mm/yyyy hh24:mi'),165,41.25);
  484. COMMIT;
  485.  
  486. INSERT INTO t_wagon VALUES(seq_t_wagon.NEXTVAL,20,1,20);
  487. INSERT INTO t_wagon VALUES(seq_t_wagon.NEXTVAL,20,1,30);
  488. INSERT INTO t_wagon VALUES(seq_t_wagon.NEXTVAL,NULL,2,20);
  489. INSERT INTO t_wagon VALUES(seq_t_wagon.NEXTVAL,NULL,2,30);
  490. COMMIT;
  491.  
  492. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,2,1);
  493. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,1);
  494. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,1);
  495. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,2,2);
  496. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,2);
  497. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,2);
  498. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,2);
  499. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,2);
  500. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,3);
  501. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,3);
  502. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,3);
  503. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,3);
  504. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,3);
  505. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,3);
  506. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,4);
  507. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,4);
  508. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,4);
  509. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,5);
  510. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,2,5);
  511. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,5);
  512. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,6);
  513. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,6);
  514. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,6);
  515. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,2,7);
  516. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,8);
  517. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,8);
  518. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,8);
  519. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,8);
  520. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,8);
  521. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,9);
  522. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,10);
  523. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,2,10);
  524. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,10);
  525. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,10);
  526. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,11);
  527. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,11);
  528. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,11);
  529. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,11);
  530. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,11);
  531. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,11);
  532. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,12);
  533. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,12);
  534. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,12);
  535. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,12);
  536. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,13);
  537. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,13);
  538. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,13);
  539. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,14);
  540. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,14);
  541. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,14);
  542. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,14);
  543. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,15);
  544. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,15);
  545. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,15);
  546. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,16);
  547. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,16);
  548. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,16);
  549. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,16);
  550. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,16);
  551. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,2,17);
  552. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,2,17);
  553. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,17);
  554. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,18);
  555. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,18);
  556. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,18);
  557. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,18);
  558. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,19);
  559. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,19);
  560. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,20);
  561. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,20);
  562. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,20);
  563. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,20);
  564. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,21);
  565. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,21);
  566. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,21);
  567. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,21);
  568. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,21);
  569. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,21);
  570. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,22);
  571. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,22);
  572. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,22);
  573. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,23);
  574. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,23);
  575. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,23);
  576. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,24);
  577. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,24);
  578. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,24);
  579. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,24);
  580. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,24);
  581. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,25);
  582. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,25);
  583. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,26);
  584. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,26);
  585. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,26);
  586. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,26);
  587. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,27);
  588. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,27);
  589. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,28);
  590. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,28);
  591. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,28);
  592. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,29);
  593. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,29);
  594. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,30);
  595. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,31);
  596. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,31);
  597. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,31);
  598. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,32);
  599. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,32);
  600. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,33);
  601. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,33);
  602. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,33);
  603. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,34);
  604. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,34);
  605. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,35);
  606. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,35);
  607. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,36);
  608. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,36);
  609. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,37);
  610. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,37);
  611. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,37);
  612. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,37);
  613. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,38);
  614. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,38);
  615. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,39);
  616. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,39);
  617. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,39);
  618. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,40);
  619. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,40);
  620. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,41);
  621. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,41);
  622. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,4,41);
  623. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,42);
  624. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,3,42);
  625. INSERT INTO t_wagon_train VALUES(seq_t_wagon_train.NEXTVAL,1,42);
  626. COMMIT;
  627.  
  628. -- Activation des contraintes
  629. ALTER TABLE T_PASS
  630.     ENABLE CONSTRAINT PK_PASS;
  631.  
  632. ALTER TABLE T_CUSTOMER
  633.     ENABLE CONSTRAINT PK_CUSTOMER;
  634.  
  635. ALTER TABLE T_CUSTOMER
  636.     ENABLE CONSTRAINT FK_PASS_CUSTOMER;
  637.  
  638. ALTER TABLE T_STATION
  639.     ENABLE CONSTRAINT PK_STATION;
  640.  
  641. ALTER TABLE T_WAGON
  642.     ENABLE CONSTRAINT PK_WAGON;
  643.  
  644. ALTER TABLE T_WAGON_TRAIN
  645.     ENABLE CONSTRAINT PK_WAGON_TRAIN;
  646.  
  647. ALTER TABLE T_WAGON_TRAIN
  648.     ENABLE CONSTRAINT FK_TRAIN_WAGON_TRAIN;
  649.  
  650. ALTER TABLE T_WAGON_TRAIN
  651.     ENABLE CONSTRAINT FK_WAGON_WAGON_TRAIN;
  652.  
  653. ALTER TABLE T_RESERVATION
  654.     ENABLE CONSTRAINT PK_RESERVATION;
  655.  
  656. ALTER TABLE T_RESERVATION
  657.     ENABLE CONSTRAINT FK_CUSTOMER_RESERVATION;
  658.  
  659. ALTER TABLE T_RESERVATION
  660.     ENABLE CONSTRAINT FK_EMPLOYEE_RESERVATION;
  661.  
  662. ALTER TABLE T_EMPLOYEE
  663.     ENABLE CONSTRAINT PK_EMPLOYEE;
  664.  
  665. ALTER TABLE T_EMPLOYEE
  666.     ENABLE CONSTRAINT FK_EMPLOYEE_EMPLOYEE;
  667.  
  668. ALTER TABLE T_TICKET
  669.     ENABLE CONSTRAINT PK_TICKET;
  670.  
  671. ALTER TABLE T_TICKET
  672.     ENABLE CONSTRAINT FK_CUSTOMER_TICKET;
  673.  
  674. ALTER TABLE T_TICKET
  675.     ENABLE CONSTRAINT FK_WAGON_TRAIN_TICKET;
  676.  
  677. ALTER TABLE T_TICKET
  678.     ENABLE CONSTRAINT FK_RESERVATION_TICKET;
  679.  
  680. ALTER TABLE T_TRAIN
  681.     ENABLE CONSTRAINT PK_TRAIN;
  682.  
  683. ALTER TABLE T_TRAIN
  684.     ENABLE CONSTRAINT FK_STATION_TRAIN_DEPARTURE;
  685.  
  686. ALTER TABLE T_TRAIN
  687.     ENABLE CONSTRAINT FK_STATION_TRAIN_ARRIVAL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!