insert into B_TYPE values ('submarine',45,55,32);
insert into B_TYPE values ('umbrella',4,2,7);
insert into B_TYPE values ('clipper',19,60,17);
insert into B_TYPE values ('steamer',123,656,58);
insert into B_TYPE values ('canoe',1,3,7);

insert into BOAT values (1,'Jane','submarine','yellow');
insert into BOAT values (2,'Mariane',NULL,'blue');
insert into BOAT values (3,'Skyla','submarine','black');
insert into BOAT values (4,'Pooh','umbrella','brown');
insert into BOAT values (5,'Shark','submarine','pink');
insert into BOAT values (6,'Carmen','clipper','green');
insert into BOAT values (7,'Yeanifer','steamer','black');
insert into BOAT values (8,'Charibda','steamer','blue');
insert into BOAT values (9,'Anne',NULL,'green');
insert into BOAT values (10,'Lilien','clipper','blue');



insert into SAILOR values (1,'Dustin',45,7);
insert into SAILOR values (2,'Lubber',55,8);
insert into SAILOR values (3,'Rusty',35,10);
insert into SAILOR values (4,'Yuppy',35,9);
insert into SAILOR values (5,'Guppy',35,5);
insert into SAILOR values (6,'Zorba',16,10);
insert into SAILOR values (7,'Horatio',35,7);
insert into SAILOR values (8,'Brutus',33,1);
insert into SAILOR values (9,'Marco',26,2);
insert into SAILOR values (10,'John',118,6);
insert into SAILOR values (11,'Charon',600,4);


insert into CUSTOMER values (1,'Ford');
insert into CUSTOMER values (2,'Smith');
insert into CUSTOMER values (3,'Blake');
insert into CUSTOMER values (4,'Allen');
insert into CUSTOMER values (5,'Ward');
insert into CUSTOMER values (6,'Martin');
insert into CUSTOMER values (7,'Scott');
insert into CUSTOMER values (8,'Turner');
insert into CUSTOMER values (9,'Adams');
insert into CUSTOMER values (10,'James');


insert into REG_LINE values (1,'Horni Plana','Hurka');
insert into REG_LINE values (2,'Hurka','Jestrabi');
insert into REG_LINE values (3,'Karlovy Dvory','Radislav');
insert into REG_LINE values (4,'Dolni Vlatavice','Kyselov');
insert into REG_LINE values (5,'Hrustice','Vetrnik');
insert into REG_LINE values (6,'Lipno','Nove Domky');
insert into REG_LINE values (7,'Nova Pec','Hurka');
insert into REG_LINE values (8,'Kyselov','Kovarov');
insert into REG_LINE values (9,'Jenisov','Blizsi Lhota');
insert into REG_LINE values (10,'Zadni Hamry','Olsina');


alter session set NLS_DATE_FORMAT = 'HH24:MI';

insert into REG_LINE_REL values (1,1,'05:30');
insert into REG_LINE_REL values (1,2,'07:50');
insert into REG_LINE_REL values (1,3,'11:25');
insert into REG_LINE_REL values (1,4,'15:50');
insert into REG_LINE_REL values (1,5,'18:00');
insert into REG_LINE_REL values (2,1,'12:00');
insert into REG_LINE_REL values (2,2,'13:10');
insert into REG_LINE_REL values (2,3,'22:20');
insert into REG_LINE_REL values (3,1,'09:10');
insert into REG_LINE_REL values (3,2,'18:45');
insert into REG_LINE_REL values (3,3,'23:00');
insert into REG_LINE_REL values (4,1,'02:10');
insert into REG_LINE_REL values (4,2,'05:55');
insert into REG_LINE_REL values (4,3,'19:35');
insert into REG_LINE_REL values (5,1,'08:00');
insert into REG_LINE_REL values (6,1,'09:20');
insert into REG_LINE_REL values (7,1,'12:12');
insert into REG_LINE_REL values (8,1,'19:35');
insert into REG_LINE_REL values (9,1,'23:59');

alter session set NLS_DATE_FORMAT = 'DD-MON-RR';

insert into REG_LINE_REL_COVER values (1,1,'01-JAN-01',1,11);
insert into REG_LINE_REL_COVER values (1,1,'24-DEC-00',1,11);
insert into REG_LINE_REL_COVER values (1,2,'01-JAN-01',8,8);
insert into REG_LINE_REL_COVER values (1,3,'01-JAN-01',2,2);
insert into REG_LINE_REL_COVER values (1,4,'01-JAN-01',5,3);
insert into REG_LINE_REL_COVER values (1,5,'01-JAN-01',6,4);
insert into REG_LINE_REL_COVER values (2,1,'01-JAN-01',9,9);
insert into REG_LINE_REL_COVER values (2,2,'01-JAN-01',10,10);
insert into REG_LINE_REL_COVER values (2,3,'02-JAN-01',1,11);
insert into REG_LINE_REL_COVER values (3,1,'02-JAN-01',8,8);
insert into REG_LINE_REL_COVER values (3,2,'02-JAN-01',2,3);
insert into REG_LINE_REL_COVER values (3,3,'24-DEC-00',8,8);
insert into REG_LINE_REL_COVER values (4,1,'24-DEC-00',5,11);
insert into REG_LINE_REL_COVER values (4,2,'24-DEC-00',9,3);
insert into REG_LINE_REL_COVER values (4,3,'24-DEC-00',1,2);
insert into REG_LINE_REL_COVER values (5,1,'24-DEC-00',2,4);
insert into REG_LINE_REL_COVER values (6,1,'24-DEC-00',5,9);
insert into REG_LINE_REL_COVER values (7,1,'24-DEC-00',6,10);
insert into REG_LINE_REL_COVER values (1,1,'10-JUL-00',8,8);
insert into REG_LINE_REL_COVER values (1,1,'08-SEP-00',1,11);

insert into RESERVATION values (1,6,'01-JAN-01');
insert into RESERVATION values (8,1,'01-JAN-01');
insert into RESERVATION values (5,7,'01-JAN-01');
insert into RESERVATION values (9,3,'01-JAN-01');
insert into RESERVATION values (1,6,'24-DEC-00');
insert into RESERVATION values (8,1,'24-DEC-00');
insert into RESERVATION values (7,7,'24-DEC-00');
insert into RESERVATION values (2,9,'24-DEC-00');

insert into SAIL_WITH_GUIDE values (1,1,6,'01-JAN-01');
insert into SAIL_WITH_GUIDE values (1,1,6,'02-JAN-01');
insert into SAIL_WITH_GUIDE values (1,1,6,'03-JAN-01');
insert into SAIL_WITH_GUIDE values (1,1,6,'04-JAN-01');
insert into SAIL_WITH_GUIDE values (1,1,6,'05-JAN-01');
insert into SAIL_WITH_GUIDE values (1,1,6,'06-JAN-01');
insert into SAIL_WITH_GUIDE values (1,1,6,'07-JAN-01');
insert into SAIL_WITH_GUIDE values (2,8,1,'01-JAN-01');
insert into SAIL_WITH_GUIDE values (3,6,7,'01-JAN-01');
insert into SAIL_WITH_GUIDE values (4,9,2,'01-JAN-01');
insert into SAIL_WITH_GUIDE values (4,9,2,'02-JAN-01');
insert into SAIL_WITH_GUIDE values (4,9,2,'03-JAN-01');
insert into SAIL_WITH_GUIDE values (4,9,2,'04-JAN-01');
insert into SAIL_WITH_GUIDE values (5,10,9,'01-JAN-01');
insert into SAIL_WITH_GUIDE values (5,10,9,'02-JAN-01');
insert into SAIL_WITH_GUIDE values (5,10,9,'03-JAN-01');
insert into SAIL_WITH_GUIDE values (5,10,9,'04-JAN-01');
insert into SAIL_WITH_GUIDE values (5,10,9,'05-JAN-01');
insert into SAIL_WITH_GUIDE values (6,2,3,'01-JAN-01');

commit;


