INIT

ALTER session SET nls_date_format='dd.mm.yyyy hh24:mi';
--table reservation
INSERT INTO reservation(idtrainride,coachnumber,seatnumber,iduser,reservationdate)
  VALUES(1,1,1,1,TO_DATE('22.02.2012 15.55','dd.mm.yyyy hh24:mi'));
INSERT INTO reservation(idtrainride,coachnumber,seatnumber,iduser,reservationdate)
  VALUES(1,1,2,2,TO_DATE('22.02.2012 16.55','dd.mm.yyyy hh24:mi'));
INSERT INTO reservation(idtrainride,coachnumber,seatnumber,iduser,reservationdate)
  VALUES(4,1,3,5,TO_DATE('23.02.2012 20.00','dd.mm.yyyy hh24:mi'));
INSERT INTO reservation(idtrainride,coachnumber,seatnumber,iduser,reservationdate)
  VALUES(3,1,1,4,TO_DATE('24.02.2012 19.25','dd.mm.yyyy hh24:mi'));
INSERT INTO reservation(idtrainride,coachnumber,seatnumber,iduser,reservationdate)
  VALUES(3,1,2,5,TO_DATE('24.02.2012 16.00','dd.mm.yyyy hh24:mi'));