prompt PL/SQL Developer import file

prompt Created on 2014年4月29日星期二 by Administrator

set feedback off

set define off

prompt Disabling triggers for T_C_CITY...

alter table T_C_CITY disable all triggers;

prompt Disabling triggers for T_C_PROVINCE...

alter table T_C_PROVINCE disable all triggers;

prompt Deleting T_C_PROVINCE...

delete from T_C_PROVINCE;

commit;

prompt Deleting T_C_CITY...

delete from T_C_CITY;

commit;

prompt Loading T_C_CITY...

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0289', 'P0003', '筠连县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1133', 'P0015', '赤水市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1134', 'P0015', '兴义市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1135', 'P0015', '丹寨县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1136', 'P0015', '玉屏县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1137', 'P0015', '六盘水市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1138', 'P0015', '晴隆县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1139', 'P0016', '徐闻县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1140', 'P0016', '高明区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1141', 'P0016', '廉江市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1142', 'P0016', '潮州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1143', 'P0016', '南雄市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1144', 'P0016', '高州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1145', 'P0016', '广宁县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1146', 'P0016', '汕头市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1147', 'P0016', '汕尾市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1148', 'P0016', '四会市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1149', 'P0016', '化州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1150', 'P0016', '阳山县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1151', 'P0016', '惠州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1152', 'P0016', '龙岗区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1153', 'P0016', '郁南县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1154', 'P0016', '乐昌市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1155', 'P0016', '从化市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1156', 'P0016', '东莞市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1157', 'P0016', '番禺区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1158', 'P0016', '三水区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1159', 'P0016', '惠来县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1160', 'P0016', '连州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1161', 'P0016', '茂名市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1162', 'P0016', '英德市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1163', 'P0016', '湛江市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1164', 'P0016', '阳西县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1165', 'P0016', '翁源县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1166', 'P0016', '珠海市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1167', 'P0016', '花都区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1168', 'P0016', '澄海区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1169', 'P0016', '紫金县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1170', 'P0016', '陆丰市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1171', 'P0016', '开平市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1172', 'P0016', '吴川市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1173', 'P0016', '河源市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1174', 'P0016', '新会区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1175', 'P0016', '南澳县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1176', 'P0016', '蕉岭县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1177', 'P0016', '乳源县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1178', 'P0016', '罗定市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1179', 'P0016', '阳江市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1180', 'P0016', '广东');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1181', 'P0016', '清远市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1182', 'P0016', '新丰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1183', 'P0016', '海丰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1184', 'P0016', '南海区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1185', 'P0016', '信宜市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1186', 'P0016', '博罗县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1187', 'P0016', '佛冈县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1188', 'P0016', '始兴县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1189', 'P0016', '深圳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1190', 'P0016', '佛山市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1191', 'P0016', '曲江县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1192', 'P0016', '揭阳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1193', 'P0016', '台山市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1194', 'P0016', '梅州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1195', 'P0016', '德庆县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1196', 'P0016', '云浮市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1197', 'P0016', '饶平县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1198', 'P0016', '雷州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1199', 'P0016', '丰顺县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1200', 'P0016', '电白县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1201', 'P0016', '肇庆市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1202', 'P0016', '陆河县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1203', 'P0016', '鹤山市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1204', 'P0016', '新兴县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1205', 'P0016', '恩平市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1206', 'P0016', '仁化县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1207', 'P0016', '揭西县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1208', 'P0016', '宝安区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1209', 'P0016', '普宁市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1210', 'P0016', '连山县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1211', 'P0016', '和平县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1212', 'P0016', '连平县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1213', 'P0016', '惠阳区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1214', 'P0016', '平远县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1215', 'P0016', '潮阳区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1216', 'P0016', '潮南区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1217', 'P0016', '斗门县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1218', 'P0016', '大埔县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1219', 'P0016', '封开县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1220', 'P0016', '龙门县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1221', 'P0016', '韶关市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1222', 'P0016', '顺德区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1223', 'P0016', '怀集县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1224', 'P0016', '惠东县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1225', 'P0016', '增城市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1226', 'P0016', '龙川县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1227', 'P0016', '五华县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1228', 'P0016', '江门市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1229', 'P0016', '中山市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1230', 'P0016', '广州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1231', 'P0016', '连南县');

commit;

prompt 100 records committed...

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1232', 'P0016', '兴宁市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1233', 'P0016', '遂溪县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1234', 'P0016', '高要市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1235', 'P0017', '上饶县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1236', 'P0017', '永修县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1237', 'P0017', '宜丰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1238', 'P0017', '赣县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1239', 'P0017', '广昌县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1240', 'P0017', '余江县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1241', 'P0017', '信丰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1242', 'P0017', '分宜县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1243', 'P0017', '南昌市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1244', 'P0017', '浮梁县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1245', 'P0017', '黎川县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1246', 'P0017', '靖安县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1247', 'P0017', '德安县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1248', 'P0017', '奉新县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1249', 'P0017', '永丰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1250', 'P0017', '崇义县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1251', 'P0017', '全南县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1252', 'P0017', '进贤县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1253', 'P0017', '崇仁县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1254', 'P0017', '南康市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1255', 'P0017', '吉安县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1256', 'P0017', '宜黄县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1257', 'P0017', '湖口县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1258', 'P0017', '彭泽县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1259', 'P0017', '德兴市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1260', 'P0017', '铅山县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1261', 'P0017', '资溪县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1262', 'P0017', '南丰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1263', 'P0017', '余干县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1264', 'P0017', '遂川县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1265', 'P0017', '武宁县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1266', 'P0017', '抚州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1267', 'P0017', '江西');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1268', 'P0017', '上犹县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1269', 'P0017', '高安市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1270', 'P0017', '万载县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1271', 'P0017', '井冈山市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1272', 'P0017', '瑞昌市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1273', 'P0017', '新干县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1274', 'P0017', '万年县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1275', 'P0017', '上饶市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1276', 'P0017', '南城县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1277', 'P0017', '萍乡市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1278', 'P0017', '会昌县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1279', 'P0017', '寻乌县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1280', 'P0017', '星子县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1281', 'P0017', '兴国县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1282', 'P0017', '永新县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1283', 'P0017', '吉水县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1284', 'P0017', '龙南县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1285', 'P0017', '乐平市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1286', 'P0017', '铜鼓县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1287', 'P0017', '上高县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1288', 'P0017', '新建县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1289', 'P0017', '莲花县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1290', 'P0017', '宁都县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1291', 'P0017', '东乡县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1292', 'P0017', '九江市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1293', 'P0017', '九江县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1294', 'P0017', '瑞金市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1295', 'P0017', '景德镇市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1296', 'P0017', '贵溪市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1297', 'P0017', '乐安县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1298', 'P0017', '赣州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1299', 'P0017', '弋阳县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1300', 'P0017', '安远县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1301', 'P0017', '修水县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1302', 'P0017', '大余县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1303', 'P0017', '玉山县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1304', 'P0017', '于都县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1305', 'P0017', '安福县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1306', 'P0017', '广丰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1307', 'P0017', '婺源县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1308', 'P0017', '定南县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1309', 'P0017', '金溪县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1310', 'P0017', '横峰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1311', 'P0017', '丰城市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1312', 'P0017', '南昌县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1313', 'P0017', '都昌县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1314', 'P0017', '新余市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1315', 'P0017', '吉安市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1316', 'P0017', '宜春市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1317', 'P0017', '安义县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1318', 'P0017', '峡江县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1319', 'P0017', '鹰潭市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1320', 'P0017', '鄱阳县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1321', 'P0017', '石城县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1322', 'P0017', '樟树市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1323', 'P0017', '泰和县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1324', 'P0017', '万安县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1325', 'P0018', '祁东县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1326', 'P0018', '汉寿县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1327', 'P0018', '江永县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1328', 'P0018', '宁乡县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1329', 'P0018', '衡东县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1330', 'P0018', '湘潭县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1331', 'P0018', '醴陵市');

commit;

prompt 200 records committed...

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1332', 'P0018', '汝城县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1333', 'P0018', '邵阳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1334', 'P0018', '古丈县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1335', 'P0018', '资兴市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1336', 'P0018', '岳阳县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1337', 'P0018', '东安县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1338', 'P0018', '华容县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1339', 'P0018', '安仁县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1340', 'P0018', '沅陵县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1341', 'P0018', '安化县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1342', 'P0018', '武冈市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1343', 'P0018', '新晃县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1344', 'P0018', '祁阳县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1345', 'P0018', '临武县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1346', 'P0018', '长沙市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1347', 'P0018', '绥宁县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1348', 'P0018', '新宁县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1349', 'P0018', '津市市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1350', 'P0018', '泸溪县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1351', 'P0018', '衡山县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1352', 'P0018', '湘西州');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1353', 'P0018', '洞口县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1354', 'P0018', '中方');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1355', 'P0018', '衡阳县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1356', 'P0018', '芝山区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1357', 'P0018', '嘉禾县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1358', 'P0018', '冷水江市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1359', 'P0018', '平江县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1360', 'P0018', '双牌县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1361', 'P0018', '临湘市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1362', 'P0018', '龙山县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1363', 'P0018', '长沙县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1364', 'P0018', '株洲市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1365', 'P0018', '汨罗市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1366', 'P0018', '湘阴县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1367', 'P0018', '桃江县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1368', 'P0018', '隆回县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1369', 'P0018', '宁远县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1370', 'P0018', '溆浦县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1371', 'P0018', '宜章县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1372', 'P0018', '永州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1373', 'P0018', '保靖县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1375', 'P0018', '安乡县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1376', 'P0018', '澧县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1377', 'P0018', '通道县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1378', 'P0018', '衡阳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1379', 'P0018', '茶陵县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1380', 'P0018', '江华县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1381', 'P0018', '桂东县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1382', 'P0018', '桃源县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1383', 'P0018', '洪江市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1384', 'P0018', '湘乡市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1385', 'P0018', '邵阳县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1386', 'P0018', '攸县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1387', 'P0018', '炎陵县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1388', 'P0018', '郴州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1389', 'P0018', '娄底市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1390', 'P0018', '吉首市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1391', 'P0018', '蓝山县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1392', 'P0018', '新化县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1393', 'P0018', '韶山市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1394', 'P0018', '芷江县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1395', 'P0018', '永顺县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1396', 'P0018', '湖南');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1397', 'P0018', '辰溪县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1398', 'P0018', '常德市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1399', 'P0018', '邵东县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1400', 'P0018', '临澧县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1401', 'P0018', '永兴县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1402', 'P0018', '道县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1403', 'P0018', '常宁市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1404', 'P0018', '双峰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1405', 'P0018', '桂阳县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1406', 'P0018', '石门县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1407', 'P0018', '凤凰县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1408', 'P0018', '南岳区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1409', 'P0018', '耒阳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1410', 'P0018', '花垣县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1411', 'P0018', '新田县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1412', 'P0018', '新邵县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1413', 'P0018', '益阳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1414', 'P0018', '靖州县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1415', 'P0018', '麻阳县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1416', 'P0018', '衡南县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1417', 'P0018', '望城县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1418', 'P0018', '浏阳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1419', 'P0018', '洪江区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1420', 'P0018', '岳阳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1421', 'P0018', '沅江市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1422', 'P0018', '湘潭市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1423', 'P0018', '涟源市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1424', 'P0018', '怀化市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1425', 'P0018', '会同县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1426', 'P0018', '张家界市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1427', 'P0019', '福鼎市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1428', 'P0019', '同安区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1429', 'P0019', '长乐市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1430', 'P0019', '建瓯市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1431', 'P0019', '政和县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1432', 'P0019', '尤溪县');

commit;

prompt 300 records committed...

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C1433', 'P0019', '福清市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0290', 'P0003', '剑阁县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0291', 'P0003', '宝兴县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0292', 'P0003', '江油市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0293', 'P0003', '屏山县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0294', 'P0003', '武胜县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0295', 'P0003', '四川');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0296', 'P0003', '威远县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0297', 'P0003', '泸州市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0298', 'P0003', '雅安市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0299', 'P0003', '巴塘县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0300', 'P0003', '简阳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0301', 'P0003', '乐至县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0302', 'P0003', '兴文县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0303', 'P0003', '邛崃市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0304', 'P0003', '阿坝州');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0305', 'P0003', '茂县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0306', 'P0003', '白玉县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0307', 'P0003', '南充市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0308', 'P0003', '越西县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0309', 'P0003', '叙永县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0310', 'P0003', '理县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0311', 'P0003', '宣汉县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0312', 'P0003', '雷波县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0313', 'P0003', '什邡市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0314', 'P0003', '万源市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0315', 'P0003', '自贡市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0316', 'P0003', '凉山州');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0317', 'P0003', '巴中市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0318', 'P0003', '青白江区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0319', 'P0003', '资中县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0320', 'P0003', '石渠县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0321', 'P0003', '安县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0322', 'P0003', '木里藏族自治县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0323', 'P0003', '洪雅县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0324', 'P0003', '金川县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0325', 'P0003', '南溪县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0326', 'P0003', '丹棱县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0327', 'P0003', '温江区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0328', 'P0003', '广安市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0329', 'P0003', '纳溪区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0330', 'P0003', '会理县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0331', 'P0003', '蓬安县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0332', 'P0003', '通江县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0333', 'P0003', '旺苍县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0334', 'P0003', '汶川县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0335', 'P0003', '大竹县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0336', 'P0003', '理塘县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0337', 'P0004', '阿巴嘎旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0338', 'P0004', '凉城县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0339', 'P0004', '杭锦后旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0340', 'P0004', '五原县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0341', 'P0004', '鄂托克前旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0342', 'P0004', '和林格尔县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0343', 'P0004', '克什克腾旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0344', 'P0004', '鄂温克旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0345', 'P0004', '锡林郭勒盟');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0346', 'P0004', '商都县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0347', 'P0004', '牙克石市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0348', 'P0004', '伊金霍洛旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0349', 'P0004', '根河市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0350', 'P0004', '科尔沁左翼后旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0351', 'P0004', '阿拉善左旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0352', 'P0004', '鄂托克旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0353', 'P0004', '额尔古纳市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0354', 'P0004', '通辽市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0355', 'P0004', '奈曼旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0356', 'P0004', '察哈尔右翼前旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0357', 'P0004', '兴和县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0358', 'P0004', '四子王旗市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0359', 'P0004', '正镶白旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0360', 'P0004', '卓资县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0361', 'P0004', '扎鲁特旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0362', 'P0004', '翁牛特旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0363', 'P0004', '敖汉旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0364', 'P0004', '正蓝旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0365', 'P0004', '库伦旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0366', 'P0004', '新巴尔虎右旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0367', 'P0004', '喀喇沁旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0368', 'P0004', '土默特右旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0369', 'P0004', '托克托县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0370', 'P0004', '巴彦卓尔市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0371', 'P0004', '乌兰浩特市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0372', 'P0004', '西乌珠穆沁旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0373', 'P0004', '清水河县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0374', 'P0004', '磴口县');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0375', 'P0004', '新巴尔虎左旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0376', 'P0004', '海拉尔区');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0377', 'P0004', '乌兰察布市');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0378', 'P0004', '太仆寺旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0379', 'P0004', '鄂伦春旗');

insert into T_C_CITY (fcitycode, fprovincecode, fcityname)

values ('C0380', 'P0004', '临河市');