prompt PL/SQL Developer import file
prompt Created on 2017年3月13日 by Administrator
set feedback off
set define off
prompt Creating SYS_AREA_2017...
create table SYS_AREA_2017
(
code VARCHAR2(20) not null,
parent_code VARCHAR2(20),
name VARCHAR2(64),
province VARCHAR2(64),
city VARCHAR2(64),
district VARCHAR2(64),
full_name VARCHAR2(128)
)
tablespace TEST
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 8K
minextents 1
maxextents unlimited
);
comment on table SYS_AREA_2017
is '行政区划--全国省市县三级(2017版)';
comment on column SYS_AREA_2017.code
is '行政区划编码';
comment on column SYS_AREA_2017.parent_code
is '父级行政区划编码';
comment on column SYS_AREA_2017.name
is '名称';
comment on column SYS_AREA_2017.province
is '省';
comment on column SYS_AREA_2017.city
is '市';
comment on column SYS_AREA_2017.district
is '县';
comment on column SYS_AREA_2017.full_name
is '全称';
prompt Disabling triggers for SYS_AREA_2017...
alter table SYS_AREA_2017 disable all triggers;
prompt Loading SYS_AREA_2017...
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('140927', '140900', '神池县', '山西省', '忻州市', '神池县', '山西省忻州市神池县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('140928', '140900', '五寨县', '山西省', '忻州市', '五寨县', '山西省忻州市五寨县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('140929', '140900', '岢岚县', '山西省', '忻州市', '岢岚县', '山西省忻州市岢岚县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('140930', '140900', '河曲县', '山西省', '忻州市', '河曲县', '山西省忻州市河曲县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('140931', '140900', '保德县', '山西省', '忻州市', '保德县', '山西省忻州市保德县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('140932', '140900', '偏关县', '山西省', '忻州市', '偏关县', '山西省忻州市偏关县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('140981', '140900', '原平市', '山西省', '忻州市', '原平市', '山西省忻州市原平市');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141000', '140000', '临汾市', '山西省', '临汾市', null, '山西省临汾市');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141001', '141000', '市辖区', '山西省', '临汾市', '市辖区', '山西省临汾市市辖区');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141002', '141000', '尧都区', '山西省', '临汾市', '尧都区', '山西省临汾市尧都区');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141021', '141000', '曲沃县', '山西省', '临汾市', '曲沃县', '山西省临汾市曲沃县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141022', '141000', '翼城县', '山西省', '临汾市', '翼城县', '山西省临汾市翼城县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141023', '141000', '襄汾县', '山西省', '临汾市', '襄汾县', '山西省临汾市襄汾县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141024', '141000', '洪洞县', '山西省', '临汾市', '洪洞县', '山西省临汾市洪洞县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141025', '141000', '古县', '山西省', '临汾市', '古县', '山西省临汾市古县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141026', '141000', '安泽县', '山西省', '临汾市', '安泽县', '山西省临汾市安泽县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141027', '141000', '浮山县', '山西省', '临汾市', '浮山县', '山西省临汾市浮山县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141028', '141000', '吉县', '山西省', '临汾市', '吉县', '山西省临汾市吉县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141029', '141000', '乡宁县', '山西省', '临汾市', '乡宁县', '山西省临汾市乡宁县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141030', '141000', '大宁县', '山西省', '临汾市', '大宁县', '山西省临汾市大宁县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141031', '141000', '隰县', '山西省', '临汾市', '隰县', '山西省临汾市隰县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141032', '141000', '永和县', '山西省', '临汾市', '永和县', '山西省临汾市永和县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141033', '141000', '蒲县', '山西省', '临汾市', '蒲县', '山西省临汾市蒲县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141034', '141000', '汾西县', '山西省', '临汾市', '汾西县', '山西省临汾市汾西县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141081', '141000', '侯马市', '山西省', '临汾市', '侯马市', '山西省临汾市侯马市');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141082', '141000', '霍州市', '山西省', '临汾市', '霍州市', '山西省临汾市霍州市');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141100', '140000', '吕梁市', '山西省', '吕梁市', null, '山西省吕梁市');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141101', '141100', '市辖区', '山西省', '吕梁市', '市辖区', '山西省吕梁市市辖区');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141102', '141100', '离石区', '山西省', '吕梁市', '离石区', '山西省吕梁市离石区');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141121', '141100', '文水县', '山西省', '吕梁市', '文水县', '山西省吕梁市文水县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141122', '141100', '交城县', '山西省', '吕梁市', '交城县', '山西省吕梁市交城县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141123', '141100', '兴县', '山西省', '吕梁市', '兴县', '山西省吕梁市兴县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141124', '141100', '临县', '山西省', '吕梁市', '临县', '山西省吕梁市临县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141125', '141100', '柳林县', '山西省', '吕梁市', '柳林县', '山西省吕梁市柳林县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141126', '141100', '石楼县', '山西省', '吕梁市', '石楼县', '山西省吕梁市石楼县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141127', '141100', '岚县', '山西省', '吕梁市', '岚县', '山西省吕梁市岚县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141128', '141100', '方山县', '山西省', '吕梁市', '方山县', '山西省吕梁市方山县');
insert into SYS_AREA_2017 (code, parent_code, name, province, city, district, full_name)
values ('141129', '141100', '中阳县', '山西省', '吕梁市', '中阳县', '山西省吕
全国城市三级联动 mysql oracle 2017
需积分: 10 129 浏览量
2017-11-09
11:10:44
上传
评论
收藏 267KB ZIP 举报
sys_area_2017.zip （3个子文件） 
sys_area_2017 sys_area_2017 
sys_area_2017_oracle.sql 643KB sys_area_2017_mysql.sql 509KB
sys_area_office_2017.xls 631KB资源评论
