全国城市区县表

prompt PL/SQL Developer import file prompt Created on 2011年11月15日 by zhi set feedback off set define off prompt Creating REGION... create table REGION ( REGION_ID NUMBER not null, REGION_CODE VARCHAR2(100) not null, REGION_NAME VARCHAR2(100) not null, PARENT_ID NUMBER not null, REGION_LEVEL NUMBER not null, REGION_ORDER NUMBER not null, REGION_NAME_EN VARCHAR2(100) default 1 not null, REGION_SHORTNAME_EN VARCHAR2(10) default 2 not null ) tablespace DEMO pctfree 10 initrans 1 maxtrans 255 storage ( initial 256K minextents 1 maxextents unlimited ); comment on column REGION.REGION_ID is '行政区划id'; comment on column REGION.REGION_CODE is '行政区划代码'; comment on column REGION.REGION_NAME is '行政区划名称'; comment on column REGION.PARENT_ID is '父行政区划'; comment on column REGION.REGION_LEVEL is '层级'; comment on column REGION.REGION_ORDER is '排序，用来调整顺序'; comment on column REGION.REGION_NAME_EN is '行政区划英文名称'; comment on column REGION.REGION_SHORTNAME_EN is '行政区划简称'; alter table REGION add constraint REGION_KEY primary key (REGION_ID) using index tablespace DEMO pctfree 10 initrans 2 maxtrans 255 storage ( initial 128K minextents 1 maxextents unlimited ); prompt Loading REGION... insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2508, '450702', '钦南区', 259, 0, 0, 'Qinnan Qu', 'QNQ'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2514, '450803', '港南区', 260, 0, 0, 'Gangnan Qu', 'GNQ'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2522, '450923', '博白县', 261, 0, 0, 'Bobai Xian', 'BBA'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2527, '451021', '田阳县', 262, 0, 0, 'Tianyang Xian', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2531, '451025', '靖西县', 262, 0, 0, 'Jingxi Xian', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2534, '451028', '乐业县', 262, 0, 0, 'Leye Xian', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2537, '451031', '隆林各族自治县', 262, 0, 0, 'Longlin Gezu Zizhixian', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2542, '451123', '富川瑶族自治县', 263, 0, 0, 'Fuchuan Yaozu Zizhixian', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2549, '451225', '罗城仫佬族自治县', 264, 0, 0, 'Luocheng Mulaozu Zizhixian', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2551, '451227', '巴马瑶族自治县', 264, 0, 0, 'Bama Yaozu Zizhixian', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2554, '451281', '宜州市', 264, 0, 0, 'Yizhou Shi', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2559, '451323', '武宣县', 265, 0, 0, 'Wuxuan Xian', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2561, '451381', '合山市', 265, 0, 0, 'Heshan Shi', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (2565, '451422', '宁明县', 266, 0, 0, 'Ningming Xian', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1648, '360481', '瑞昌市', 162, 0, 0, 'Ruichang Shi', 'RCG'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1650, '360502', '渝水区', 163, 0, 0, 'Yushui Qu', 'YSR'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1651, '360521', '分宜县', 163, 0, 0, 'Fenyi Xian', 'FYI'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1652, '360601', '市辖区', 164, 0, 0, 'Shixiaqu', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1654, '360622', '余江县', 164, 0, 0, 'Yujiang Xian', 'YUJ'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1655, '360681', '贵溪市', 164, 0, 0, 'Guixi Shi', 'GXS'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1656, '360701', '市辖区', 165, 0, 0, 'Shixiaqu', '2'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1658, '360721', '赣县', 165, 0, 0, 'Gan Xian', 'GXN'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1659, '360722', '信丰县', 165, 0, 0, 'Xinfeng Xian ', 'XNF'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1660, '360723', '大余县', 165, 0, 0, 'Dayu Xian', 'DYX'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1662, '360725', '崇义县', 165, 0, 0, 'Chongyi Xian', 'CYX'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1663, '360726', '安远县', 165, 0, 0, 'Anyuan Xian', 'AYN'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1664, '360727', '龙南县', 165, 0, 0, 'Longnan Xian', 'LNX'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1666, '360729', '全南县', 165, 0, 0, 'Quannan Xian', 'QNN'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1667, '360730', '宁都县', 165, 0, 0, 'Ningdu Xian', 'NDU'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1668, '360731', '于都县', 165, 0, 0, 'Yudu Xian', 'YUD'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1670, '360733', '会昌县', 165, 0, 0, 'Huichang Xian', 'HIC'); insert into REGION (REGION_ID, REGION_CODE, REGION_NAME, PARENT_ID, REGION_LEVEL, REGION_ORDER, REGION_NAME_EN, REGION_SHORTNAME_EN) values (1671, '360734', '寻乌县', 165, 0, 0, 'Xunwu Xian', 'XNW'); insert into REGION (REGION_ID, REGION_