drop table citytime cascade constraints;

start c:\java\citytime_table.sql
start c:\java\citytime_retrieve.sql
start c:\java\citytime_insert.sql
start c:\java\citytime_update.sql
start c:\java\citytime_delete.sql
start c:\java\citytime_first.sql
start c:\java\citytime_last.sql
start c:\java\citytime_previous.sql
start c:\java\citytime_next.sql
start c:\java\citytime_retrieve2.sql

insert into citytime values(1,2,'01-Jan-98','31-Mar-98','01.00','05.00','07.00','09.00','02.00','04.00','06.00','08.00','@');
insert into citytime values(2,3,'01-Apr-98','30-Jun-98','02.00','06.00','08.00','10.00','03.00','05.00','07.00','09.00','');
insert into citytime values(3,4,'01-Jun-98','30-Aug-98','03.00','07.00','09.00','11.00','04.00','06.00','08.00','10.00','');

commit;