首先，创建表：

create table WEATHER(weatherindex varchar2(10),cityCode varchar2(20),cityName varchar2(50));

其次，插入多条数据：

INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(1, '101010100', '北京'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(2, '101010200', '海淀'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(3, '101010400', '顺义'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(4, '101010500', '怀柔'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(5, '101010600', '通州'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(6, '101010700', '昌平'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(7, '101010800', '延庆'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(8, '101010900', '丰台'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(9, '101011000', '石景山'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(10, '101011100', '大兴'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(11, '101011200', '房山'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(12, '101011300', '密云'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(13, '101011400', '门头沟'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(14, '101011500', '平谷'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(15, '101020100', '上海'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(16, '101020200', '闵行'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(17, '101020300', '宝山'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(18, '101020500', '嘉定'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(19, '101020600', '浦东南汇'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(20, '101020700', '金山'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(21, '101020800', '青浦'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(22, '101020900', '松江'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(23, '101021000', '奉贤'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(24, '101021100', '崇明'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(25, '101021300', '浦东'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(26, '101030100', '天津'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(27, '101030200', '武清'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(28, '101030300', '宝坻'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(29, '101030400', '东丽'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(30, '101030500', '西青'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(31, '101030600', '北辰'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(32, '101030700', '宁河'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(33, '101030800', '汉沽'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(34, '101030900', '静海'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(35, '101031000', '津南'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(36, '101031100', '塘沽'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(37, '101031200', '大港'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(38, '101031400', '蓟县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(39, '101040100', '重庆'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(40, '101040200', '永川'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(41, '101040300', '合川'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(42, '101040400', '南川'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(43, '101040500', '江津'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(44, '101040600', '万盛'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(45, '101040700', '渝北'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(46, '101040800', '北碚'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(47, '101041000', '长寿'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(48, '101041100', '黔江'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(49, '101041300', '万州'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(50, '101041400', '涪陵'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(51, '101041500', '开县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(52, '101041600', '城口'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(53, '101041700', '云阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(54, '101041800', '巫溪'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(55, '101041900', '奉节'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(56, '101042000', '巫山'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(57, '101042100', '潼南'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(58, '101042200', '垫江'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(59, '101042300', '梁平'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(60, '101042400', '忠县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(61, '101042500', '石柱'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(62, '101042600', '大足'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(63, '101042700', '荣昌'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(64, '101042800', '铜梁'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(65, '101042900', '璧山'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(66, '101043000', '丰都'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(67, '101043100', '武隆'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(68, '101043200', '彭水'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(69, '101043300', '綦江'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(70, '101043400', '酉阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(71, '101043600', '秀山'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(72, '101050101', '哈尔滨'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(73, '101050102', '双城'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(74, '101050103', '呼兰'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(75, '101050104', '阿城'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(76, '101050105', '宾县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(77, '101050106', '依兰'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(78, '101050107', '巴彦'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(79, '101050108', '通河'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(80, '101050109', '方正'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(81, '101050110', '延寿'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(82, '101050111', '尚志'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(83, '101050112', '五常'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(84, '101050113', '木兰'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(85, '101050201', '齐齐哈尔'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(86, '101050202', '讷河'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(87, '101050203', '龙江'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(88, '101050204', '甘南'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(89, '101050205', '富裕'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(90, '101050206', '依安'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(91, '101050207', '拜泉'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(92, '101050208', '克山'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(93, '101050209', '克东'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(94, '101050210', '泰来'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(95, '101050301', '牡丹江'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(96, '101050302', '海林'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(97, '101050303', '穆棱'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(98, '101050304', '林口'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(99, '101050305', '绥芬河'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(100, '101050306', '宁安'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(101, '101050307', '东宁'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(102, '101050401', '佳木斯'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(103, '101050402', '汤原'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(104, '101050403', '抚远'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(105, '101050404', '桦川'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(106, '101050405', '桦南'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(107, '101050406', '同江'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(305, '101080807', '乌后'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(306, '101080810', '杭锦后'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(307, '101080901', '锡林浩特'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(308, '101080903', '二连浩特'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(309, '101080904', '阿巴嘎'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(633, '101110506', '富平'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(634, '101110507', '蒲城'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(635, '101110508', '澄城'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(636, '101110509', '合阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(637, '101110510', '韩城'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(638, '101110511', '华阴'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(639, '101110601', '商洛'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(640, '101110602', '洛南'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(641, '101110603', '柞水'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(642, '101110604', '商州'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(643, '101110605', '镇安'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(644, '101110606', '丹凤'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(645, '101110607', '商南'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(646, '101110608', '山阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(647, '101110701', '安康'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(648, '101110702', '紫阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(649, '101110703', '石泉'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(650, '101110704', '汉阴'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(651, '101110705', '旬阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(652, '101110706', '岚皋'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(653, '101110707', '平利'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(654, '101110708', '白河'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(655, '101110709', '镇坪'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(656, '101110710', '宁陕'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(657, '101110801', '汉中'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(658, '101110802', '略阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(659, '101110803', '勉县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(660, '101110804', '留坝'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(661, '101110805', '洋县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(662, '101110806', '城固'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(663, '101110807', '西乡'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(664, '101110808', '佛坪'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(665, '101110809', '宁强'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(666, '101110810', '南郑'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(667, '101110811', '镇巴'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(668, '101110901', '宝鸡'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(669, '101110903', '千阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(670, '101110904', '麟游'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(671, '101110905', '岐山'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(672, '101110906', '凤翔'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(673, '101110907', '扶风'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(674, '101110908', '眉县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(675, '101110909', '太白'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(676, '101110910', '凤县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(677, '101110911', '陇县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(678, '101111001', '铜川'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(679, '101111003', '宜君'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(680, '101111101', '杨凌'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(681, '101120101', '济南'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(682, '101120103', '商河'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(683, '101120104', '章丘'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(684, '101120105', '平阴'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(685, '101120106', '济阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(686, '101120201', '青岛'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(687, '101120204', '即墨'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(688, '101120205', '胶州'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(689, '101120206', '胶南'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(690, '101120207', '莱西'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(691, '101120208', '平度'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(692, '101120301', '淄博'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(693, '101120304', '高青'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(694, '101120306', '沂源'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(695, '101120307', '桓台'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(696, '101120401', '德州'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(697, '101120402', '武城'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(698, '101120403', '临邑'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(699, '101120404', '陵县'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(700, '101120405', '齐河'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(701, '101120406', '乐陵'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(702, '101120407', '庆云'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(703, '101120408', '平原'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(704, '101120409', '宁津'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(705, '101120410', '夏津'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(706, '101120411', '禹城'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(707, '101120501', '烟台'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(708, '101120502', '莱州'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(709, '101120503', '长岛'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(710, '101120504', '蓬莱'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(711, '101120505', '龙口'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(712, '101120506', '招远'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(713, '101120507', '栖霞'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(714, '101120510', '莱阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(715, '101120511', '海阳'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(716, '101120601', '潍坊'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(717, '101120602', '青州'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(718, '101120603', '寿光'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(719, '101120604', '临朐'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(720, '101120605', '昌乐'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(721, '101120606', '昌邑'); INSERT INTO F_WEATHER(index_weather,cityCode,cityName) VALUES(722, '101120607', '安丘');

在ORACLE中执行上述sql语句既可以创建表和插入数据了，全部数据2500条，这里显示了部分；全贴出来有点浪费空间，这里仅做展示；

链接在此：http://download.csdn.net/detail/hu3971898/7570955