prompt PL/SQL Developer import file
prompt Created on 2016年11月23日 by Administrator
set feedback off
set define off
prompt Creating SYS_AREA...
create table SYS_AREA
(
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 XXX
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 8K
minextents 1
maxextents unlimited
);
comment on table SYS_AREA
is '行政区划--全国省市县三级';
comment on column SYS_AREA.code
is '行政区划编码';
comment on column SYS_AREA.parent_code
is '父级行政区划编码';
comment on column SYS_AREA.name
is '名称';
comment on column SYS_AREA.province
is '省';
comment on column SYS_AREA.city
is '市';
comment on column SYS_AREA.district
is '县';
comment on column SYS_AREA.full_name
is '全称';
prompt Disabling triggers for SYS_AREA...
alter table SYS_AREA disable all triggers;
prompt Deleting SYS_AREA...
delete from SYS_AREA;
commit;
prompt Loading SYS_AREA...
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540236', '540200', '萨嘎县', '西藏自治区', '日喀则市', '萨嘎县', '西藏自治区日喀则市萨嘎县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540237', '540200', '岗巴县', '西藏自治区', '日喀则市', '岗巴县', '西藏自治区日喀则市岗巴县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540300', '540000', '昌都市', '西藏自治区', '昌都市', null, '西藏自治区昌都市');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540302', '540300', '卡若区', '西藏自治区', '昌都市', '卡若区', '西藏自治区昌都市卡若区');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540321', '540300', '江达县', '西藏自治区', '昌都市', '江达县', '西藏自治区昌都市江达县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540322', '540300', '贡觉县', '西藏自治区', '昌都市', '贡觉县', '西藏自治区昌都市贡觉县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540323', '540300', '类乌齐县', '西藏自治区', '昌都市', '类乌齐县', '西藏自治区昌都市类乌齐县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540324', '540300', '丁青县', '西藏自治区', '昌都市', '丁青县', '西藏自治区昌都市丁青县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540325', '540300', '察雅县', '西藏自治区', '昌都市', '察雅县', '西藏自治区昌都市察雅县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540326', '540300', '八宿县', '西藏自治区', '昌都市', '八宿县', '西藏自治区昌都市八宿县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540327', '540300', '左贡县', '西藏自治区', '昌都市', '左贡县', '西藏自治区昌都市左贡县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540328', '540300', '芒康县', '西藏自治区', '昌都市', '芒康县', '西藏自治区昌都市芒康县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540329', '540300', '洛隆县', '西藏自治区', '昌都市', '洛隆县', '西藏自治区昌都市洛隆县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540330', '540300', '边坝县', '西藏自治区', '昌都市', '边坝县', '西藏自治区昌都市边坝县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540400', '540000', '林芝市', '西藏自治区', '林芝市', null, '西藏自治区林芝市');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540402', '540400', '巴宜区', '西藏自治区', '林芝市', '巴宜区', '西藏自治区林芝市巴宜区');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540421', '540400', '工布江达县', '西藏自治区', '林芝市', '工布江达县', '西藏自治区林芝市工布江达县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540422', '540400', '米林县', '西藏自治区', '林芝市', '米林县', '西藏自治区林芝市米林县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540423', '540400', '墨脱县', '西藏自治区', '林芝市', '墨脱县', '西藏自治区林芝市墨脱县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540424', '540400', '波密县', '西藏自治区', '林芝市', '波密县', '西藏自治区林芝市波密县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540425', '540400', '察隅县', '西藏自治区', '林芝市', '察隅县', '西藏自治区林芝市察隅县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('540426', '540400', '朗县', '西藏自治区', '林芝市', '朗县', '西藏自治区林芝市朗县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542200', '540000', '山南地区', '西藏自治区', '山南地区', null, '西藏自治区山南地区');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542221', '542200', '乃东县', '西藏自治区', '山南地区', '乃东县', '西藏自治区山南地区乃东县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542222', '542200', '扎囊县', '西藏自治区', '山南地区', '扎囊县', '西藏自治区山南地区扎囊县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542223', '542200', '贡嘎县', '西藏自治区', '山南地区', '贡嘎县', '西藏自治区山南地区贡嘎县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542224', '542200', '桑日县', '西藏自治区', '山南地区', '桑日县', '西藏自治区山南地区桑日县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542225', '542200', '琼结县', '西藏自治区', '山南地区', '琼结县', '西藏自治区山南地区琼结县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542226', '542200', '曲松县', '西藏自治区', '山南地区', '曲松县', '西藏自治区山南地区曲松县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542227', '542200', '措美县', '西藏自治区', '山南地区', '措美县', '西藏自治区山南地区措美县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542228', '542200', '洛扎县', '西藏自治区', '山南地区', '洛扎县', '西藏自治区山南地区洛扎县');
insert into SYS_AREA (code, parent_code, name, province, city, district, full_name)
values ('542229', '542200', '加查县', '西藏自治区', '山南地区', '加查县', '西藏自治区山南地区加查县');
insert into SYS_AREA (code, parent_code, name, p