drop table city cascade constraints;

start c:\java\city_table;
start c:\java\city_insert;
start c:\java\city_update;
start c:\java\city_retrieve;
start c:\java\city_first;
start c:\java\city_last;
start c:\java\city_next;
start c:\java\city_previous;

insert into city values(' 21','DHAHRAN',        'DHA', '', '098', '+03.00', 'NULL', '', '', '', '', '');
insert into city values('0832','GOA ',          'GOI', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values('  1','COPENHAGEN',     'CPH', '', '033', '+01.00', 'NULL', '', '', '', '', '');
insert into city values('974','DOHA',           'DOH', '', '966', '+03.00', 'NULL', '', '', '', '', '');
insert into city values('965','KUWAIT',         'KWI', '', '965', '+03.00', 'NULL', '', '', '', '', '');
insert into city values(' 81','LONDON EXTERIOR','LON', '', '044', '+00.00', 'NULL', '', '', '', '', '');
insert into city values('230','MAURITIUS',      'MRU', '', '230', '+04.00', 'NULL', '', '', '', '', '');
insert into city values('968','MUSCAT',         'MCT', '', '968', '+04.00', 'NULL', '', '', '', '', '');
insert into city values(' 65','SINGAPORE',      'SIN', '', '065', '+08.00', 'NULL', '', '', '', '', '');
insert into city values('  2','ABU DHABI',      'AUH', '', '971', '+04.00', 'NULL', '', '', '', '', '');
insert into city values('079','AHMEDABAD',      'AMD', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values(' 21','BAHRAIN',        'BAH', '', '098', '+03.00', 'NULL', '', '', '', '', '');
insert into city values('080','BANGALORE',      'BLR', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values('  2','BANGKOK',        'BKK', '', '066', '+07.00', 'NULL', '', '', '', '', '');
insert into city values('033','CALCUTTA',       'CCU', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values('044','CHENNAI',        'MAA', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values('312','CHICAGO',        'CHI', '', '001', '-06.00', 'NULL', '', '', '', '', '');
insert into city values(' 51','DAR-ES-SALAAM',  'DAR', '', '966', '+03.00', 'NULL', '', '', '', '', '');
insert into city values('011','DELHI',          'DEL', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values('  4','DUBAI',          'DXB', '', '971', '+03.00', 'NULL', '', '', '', '', '');
insert into city values(' 69','FRANKFURT',      'FRA', '', '049', '+03.00', 'NULL', '', '', '', '', '');
insert into city values(' 22','GENEVA',         'GVA', '', '041', '+03.00', 'NULL', '', '', '', '', '');
insert into city values('  5','HONGKONG',       'HKG', '', '852', '+08.00', 'NULL', '', '', '', '', '');
insert into city values('040','HYDERABAD',      'HYD', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values(' 21','JAKARTA',        'JKT', '', '062', '+07.00', 'NULL', '', '', '', '', '');
insert into city values('  2','JEDDAH',         'JED', '', '966', '+03.00', 'NULL', '', '', '', '', '');
insert into city values('0495','KOZHIKODE',     'CCJ', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values('  3','KUALA LUMPUR',   'KUL', '', '060', '+08.00', 'NULL', '', '', '', '', '');
insert into city values(' 61','MANCHESTER',     'MAN', '', '044', '+00.00', 'NULL', '', '', '', '', '');
insert into city values('095','MOSCOW',         'MOW', '', '007', '+03.00', 'NULL', '', '', '', '', '');
insert into city values('022','MUMBAI',         'BOM', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values('  2','NAIROBI',        'NBO', '', '234', '+03.00', 'NULL', '', '', '', '', '');
insert into city values('718','NEW YORK',       'NYC', '', '001', '-05.00', 'NULL', '', '', '', '', '');
insert into city values('  6','OSAKA',          'OSA', '', '081', '+09.00', 'NULL', '', '', '', '', '');
insert into city values('  1','PARIS',          'PAR', '', '033', '+01.00', 'NULL', '', '', '', '', '');
insert into city values('  1','RIYADH',         'RUH', '', '966', '+03.00', 'NULL', '', '', '', '', '');
insert into city values('  6','ROME',           'ROM', '', '039', '+01.00', 'NULL', '', '', '', '', '');
insert into city values('  2','SEOUL',          'SEL', '', '082', '+09.00', 'NULL', '', '', '', '', '');
insert into city values('  3','TEL AVIV',       'TLV', '', '972', '+02.00', 'NULL', '', '', '', '', '');
insert into city values('0471','THIRUVANANTHAPURAM','TRV', '', '091', '+05.30', 'NULL', '', '', '', '', '');
insert into city values('  3','TOKYO',          'TYO', '', '081', '+09.00', 'NULL', '', '', '', '', '');
insert into city values('222','VIENNA',         'VIE', '', '043', '+01.00', 'NULL', '', '', '', '', '');
insert into city values('202','WASHINGTON',     'WAS', '', '001', '-05.00', 'NULL', '', '', '', '', '');

commit;