prompt PL/SQL Developer import file
prompt Created on 2022年1月5日 by 曾曾
set feedback off
set define off
prompt Creating LOCATION...
create table LOCATION
(
locid NUMBER not null,
loc VARCHAR2(255),
locfid NUMBER,
loclevel NUMBER,
language NUMBER
)
tablespace USERS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
prompt Disabling triggers for LOCATION...
alter table LOCATION disable all triggers;
prompt Deleting LOCATION...
delete from LOCATION;
commit;
prompt Loading LOCATION...
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110000, '北京市', 0, 1, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110101, '东城区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110102, '西城区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110105, '朝阳区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110106, '丰台区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110107, '石景山区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110108, '海淀区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110109, '门头沟区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110111, '房山区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110112, ' 通州区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110113, ' 顺义区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110114, '昌平区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110115, '大兴区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110116, '怀柔区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110117, '平谷区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110118, '密云区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (110119, '延庆区', 110000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120000, '天津市', 0, 1, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120101, '和平区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120102, '河东区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120103, '河西区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120104, '南开区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120105, '河北区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120106, '红桥区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120110, '东丽区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120111, '西青区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120112, '津南区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120113, '北辰区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120114, '武清区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120115, '宝坻区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120116, '滨海新区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120117, '宁河区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120118, '静海区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (120119, '蓟州区', 120000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130000, '河北省', 0, 1, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130100, '石家庄市', 130000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130102, '长安区', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130104, '桥西区', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130105, '新华区', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130107, '井陉矿区', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130108, '裕华区', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130109, '藁城区', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130110, '鹿泉区', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130111, '栾城区', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130121, '井陉县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130123, '正定县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130125, '行唐县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130126, '灵寿县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130127, '高邑县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130128, '深泽县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130129, '赞皇县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130130, '无极县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130131, '平山县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130132, '元氏县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130133, '赵县', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130181, '辛集市', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130183, '晋州市', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130184, '新乐市', 130100, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130200, '唐山市', 130000, 2, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130202, '路南区', 130200, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130203, '路北区', 130200, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130204, '古冶区', 130200, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130205, '开平区', 130200, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (32, '新疆维吾尔自治区', 1, null, null);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (33, '香港特别行政区', 1, null, null);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (34, '澳门特别行政区', 1, null, null);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130207, '丰南区', 130200, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130208, '丰润区', 130200, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130209, '曹妃甸区', 130200, 3, 0);
insert into LOCATION (locid, loc, locfid, loclevel, language)
values (130224, '滦南县', 130200, 3, 0);
insert into LOCAT
评论0