Oracle 递归查询

最新推荐文章于 2022-11-23 16:59:48 发布
最新推荐文章于 2022-11-23 16:59:48 发布
阅读量579 收藏
点赞数
分类专栏： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_35354529/article/details/97303829
版权

oracle递归查询语法：
select … from tablename where 条件4 start with 条件1 connect by prior 条件2 AND 条件3

--查询子节点
select * from dh_area t
start with t.areaid = 1
connect by prior t.areaid = t.parentid;

--查询父节点
select * from dh_area t
start with t.areaid = 200312
connect by prior t.parentid = t.areaid;

1.DDL

CREATE TABLE "SYSTEM"."DH_AREA" 
   (	"AREAID" VARCHAR2(10 BYTE), 
	"PARENTID" VARCHAR2(10 BYTE), 
	"AREANAME" VARCHAR2(50 BYTE), 
	"AREALEVEL" NUMBER(*,0)
   ) ;
   COMMENT ON COLUMN "SYSTEM"."DH_AREA"."AREAID" IS '地区ID';
   COMMENT ON COLUMN "SYSTEM"."DH_AREA"."PARENTID" IS 'PARENTID';
   COMMENT ON COLUMN "SYSTEM"."DH_AREA"."AREANAME" IS '地区名称';
   COMMENT ON COLUMN "SYSTEM"."DH_AREA"."AREALEVEL" IS '地区等级:0-国家 1-省 2-市 3-区';
   
   ALTER TABLE "SYSTEM"."DH_AREA" ADD PRIMARY KEY ("AREAID")

2.Insert语句

Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100004','1','山西省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('1',null,'中国',0);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100001','1','北京市',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100002','1','天津市',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100003','1','河北省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100005','1','内蒙古自治区',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100006','1','辽宁省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100007','1','吉林省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100008','1','黑龙江省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100009','1','上海市',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100010','1','江苏省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100011','1','浙江省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100012','1','安徽省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100013','1','福建省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100014','1','江西省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100015','1','山东省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100016','1','河南省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100017','1','湖北省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100018','1','湖南省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100019','1','广东省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100020','1','广西壮族自治区',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100021','1','海南省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100022','1','重庆市',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100023','1','四川省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100024','1','贵州省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100025','1','云南省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100026','1','西藏自治区',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100027','1','陕西省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100028','1','甘肃省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100029','1','青海省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100030','1','宁夏回族自治区',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100031','1','新疆维吾尔自治区',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100032','1','香港特别行政区',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100033','1','澳门特别行政区',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('100034','1','台湾省',1);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200303','100028','武威市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200304','100028','张掖市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200305','100028','平凉市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200306','100028','酒泉市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200307','100028','庆阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200308','100028','定西市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200309','100028','陇南市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200310','100028','临夏回族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200311','100028','甘南藏族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200312','100029','西宁市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200313','100029','海东地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200314','100029','海北藏族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200315','100029','黄南藏族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200316','100029','海南藏族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200317','100029','果洛藏族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200318','100029','玉树藏族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200319','100029','海西蒙古族藏族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200320','100030','银川市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200321','100030','石嘴山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200322','100030','吴忠市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200323','100030','固原市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200324','100030','中卫市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200325','100031','乌鲁木齐市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200326','100031','克拉玛依市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200327','100031','吐鲁番地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200328','100031','哈密地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200329','100031','昌吉回族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200330','100031','博尔塔拉蒙古自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200331','100031','巴音郭楞蒙古自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200332','100031','阿克苏地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200333','100031','克孜勒苏柯尔克孜自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200334','100031','喀什地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200335','100031','和田地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200336','100031','伊犁哈萨克自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200337','100031','塔城地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200338','100031','阿勒泰地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200339','100031','石河子市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200340','100031','阿拉尔市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200341','100031','图木舒克市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200342','100031','五家渠市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200343','100032','香港特别行政区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200344','100033','澳门特别行政区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200345','100034','台湾省',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200101','100012','淮南市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200102','100012','马鞍山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200103','100012','淮北市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200104','100012','铜陵市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200105','100012','安庆市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200106','100012','黄山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200107','100012','滁州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200108','100012','阜阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200109','100012','宿州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200110','100012','巢湖市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200111','100012','六安市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200112','100012','亳州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200113','100012','池州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200114','100012','宣城市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200115','100013','福州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200116','100013','厦门市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200117','100013','莆田市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200118','100013','三明市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200119','100013','泉州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200120','100013','漳州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200121','100013','南平市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200122','100013','龙岩市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200123','100013','宁德市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200124','100014','南昌市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200125','100014','景德镇市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200126','100014','萍乡市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200127','100014','九江市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200128','100014','新余市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200129','100014','鹰潭市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200130','100014','赣州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200131','100014','吉安市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200132','100014','宜春市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200133','100014','抚州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200134','100014','上饶市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200135','100015','济南市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200136','100015','青岛市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200137','100015','淄博市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200138','100015','枣庄市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200139','100015','东营市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200140','100015','烟台市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200141','100015','潍坊市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200142','100015','济宁市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200143','100015','泰安市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200144','100015','威海市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200145','100015','日照市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200146','100015','莱芜市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200147','100015','临沂市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200148','100015','德州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200149','100015','聊城市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200150','100015','滨州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200151','100015','荷泽市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200152','100016','郑州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200153','100016','开封市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200154','100016','洛阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200155','100016','平顶山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200156','100016','安阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200157','100016','鹤壁市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200158','100016','新乡市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200159','100016','焦作市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200160','100016','濮阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200161','100016','许昌市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200162','100016','漯河市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200163','100016','三门峡市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200164','100016','南阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200165','100016','商丘市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200166','100016','信阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200167','100016','周口市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200168','100016','驻马店市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200169','100017','武汉市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200170','100017','黄石市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200171','100017','十堰市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200172','100017','宜昌市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200173','100017','襄樊市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200174','100017','鄂州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200175','100017','荆门市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200176','100017','孝感市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200177','100017','荆州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200178','100017','黄冈市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200179','100017','咸宁市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200180','100017','随州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200181','100017','恩施土家族苗族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200182','100017','神农架',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200183','100018','长沙市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200184','100018','株洲市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200185','100018','湘潭市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200186','100018','衡阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200187','100018','邵阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200188','100018','岳阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200189','100018','常德市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200190','100018','张家界市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200191','100018','益阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200192','100018','郴州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200193','100018','永州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200194','100018','怀化市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200195','100018','娄底市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200196','100018','湘西土家族苗族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200197','100019','广州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200198','100019','韶关市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200199','100019','深圳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200200','100019','珠海市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200201','100019','汕头市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200001','100001','北京市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200002','100002','天津市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200003','100003','石家庄市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200004','100003','唐山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200005','100003','秦皇岛市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200006','100003','邯郸市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200007','100003','邢台市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200008','100003','保定市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200009','100003','张家口市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200010','100003','承德市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200011','100003','沧州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200012','100003','廊坊市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200013','100003','衡水市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200014','100004','太原市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200015','100004','大同市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200016','100004','阳泉市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200017','100004','长治市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200018','100004','晋城市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200019','100004','朔州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200020','100004','晋中市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200021','100004','运城市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200022','100004','忻州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200023','100004','临汾市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200024','100004','吕梁市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200025','100005','呼和浩特市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200026','100005','包头市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200027','100005','乌海市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200028','100005','赤峰市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200029','100005','通辽市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200030','100005','鄂尔多斯市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200031','100005','呼伦贝尔市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200032','100005','巴彦淖尔市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200033','100005','乌兰察布市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200034','100005','兴安盟',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200035','100005','锡林郭勒盟',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200036','100005','阿拉善盟',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200037','100006','沈阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200038','100006','大连市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200039','100006','鞍山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200040','100006','抚顺市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200041','100006','本溪市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200042','100006','丹东市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200043','100006','锦州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200044','100006','营口市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200045','100006','阜新市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200046','100006','辽阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200047','100006','盘锦市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200048','100006','铁岭市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200049','100006','朝阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200050','100006','葫芦岛市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200051','100007','长春市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200052','100007','吉林市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200053','100007','四平市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200054','100007','辽源市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200055','100007','通化市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200056','100007','白山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200057','100007','松原市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200058','100007','白城市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200059','100007','延边朝鲜族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200060','100008','哈尔滨市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200061','100008','齐齐哈尔市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200062','100008','鸡西市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200063','100008','鹤岗市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200064','100008','双鸭山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200065','100008','大庆市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200066','100008','伊春市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200067','100008','佳木斯市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200068','100008','七台河市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200069','100008','牡丹江市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200070','100008','黑河市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200071','100008','绥化市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200072','100008','大兴安岭地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200073','100009','上海市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200074','100010','南京市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200075','100010','无锡市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200076','100010','徐州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200077','100010','常州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200078','100010','苏州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200079','100010','南通市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200080','100010','连云港市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200081','100010','淮安市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200082','100010','盐城市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200083','100010','扬州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200084','100010','镇江市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200085','100010','泰州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200086','100010','宿迁市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200087','100011','杭州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200088','100011','宁波市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200089','100011','温州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200090','100011','嘉兴市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200091','100011','湖州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200092','100011','绍兴市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200093','100011','金华市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200094','100011','衢州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200095','100011','舟山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200096','100011','台州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200097','100011','丽水市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200098','100012','合肥市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200099','100012','芜湖市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200100','100012','蚌埠市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200202','100019','佛山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200203','100019','江门市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200204','100019','湛江市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200205','100019','茂名市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200206','100019','肇庆市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200207','100019','惠州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200208','100019','梅州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200209','100019','汕尾市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200210','100019','河源市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200211','100019','阳江市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200212','100019','清远市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200213','100019','东莞市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200214','100019','中山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200215','100019','潮州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200216','100019','揭阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200217','100019','云浮市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200218','100020','南宁市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200219','100020','柳州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200220','100020','桂林市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200221','100020','梧州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200222','100020','北海市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200223','100020','防城港市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200224','100020','钦州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200225','100020','贵港市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200226','100020','玉林市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200227','100020','百色市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200228','100020','贺州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200229','100020','河池市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200230','100020','来宾市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200231','100020','崇左市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200232','100021','海口市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200233','100021','三亚市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200234','100022','重庆市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200235','100023','成都市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200236','100023','自贡市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200237','100023','攀枝花市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200238','100023','泸州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200239','100023','德阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200240','100023','绵阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200241','100023','广元市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200242','100023','遂宁市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200243','100023','内江市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200244','100023','乐山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200245','100023','南充市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200246','100023','眉山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200247','100023','宜宾市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200248','100023','广安市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200249','100023','达州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200250','100023','雅安市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200251','100023','巴中市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200252','100023','资阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200253','100023','阿坝藏族羌族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200254','100023','甘孜藏族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200255','100023','凉山彝族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200256','100024','贵阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200257','100024','六盘水市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200258','100024','遵义市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200259','100024','安顺市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200260','100024','铜仁地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200261','100024','黔西南布依族苗族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200262','100024','毕节地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200263','100024','黔东南苗族侗族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200264','100024','黔南布依族苗族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200265','100025','昆明市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200266','100025','曲靖市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200267','100025','玉溪市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200268','100025','保山市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200269','100025','昭通市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200270','100025','丽江市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200271','100025','思茅市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200272','100025','临沧市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200273','100025','楚雄彝族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200274','100025','红河哈尼族彝族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200275','100025','文山壮族苗族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200276','100025','西双版纳傣族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200277','100025','大理白族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200278','100025','德宏傣族景颇族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200279','100025','怒江傈僳族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200280','100025','迪庆藏族自治州',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200281','100026','拉萨市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200282','100026','昌都地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200283','100026','山南地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200284','100026','日喀则地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200285','100026','那曲地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200286','100026','阿里地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200287','100026','林芝地区',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200288','100027','西安市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200289','100027','铜川市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200290','100027','宝鸡市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200291','100027','咸阳市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200292','100027','渭南市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200293','100027','延安市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200294','100027','汉中市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200295','100027','榆林市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200296','100027','安康市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200297','100027','商洛市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200298','100028','兰州市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200299','100028','嘉峪关市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200300','100028','金昌市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200301','100028','白银市',2);
Insert into SYSTEM.DH_AREA (AREAID,PARENTID,AREANAME,AREALEVEL) values ('200302','100028','天水市',2);
DG_DH168
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
深入sql oracle递归查询
09-10
本篇文章是对sql oracle 递归查询进行了详细的分析介绍，需要的朋友参考下
Oracle中递归查询（START WITH……CONNECT BY……）
最新发布
时代各有不同，青春一脉相承。
06-19 810
在Oracle中START WITH……CONNECT BY……一般用来查找存在父子关系的数据，也就是树形结构的数据。start with设置起点，用来限制第一层的数据，或者叫根节点数据；connect by用来指明在查找数据时以怎样的一种关系去查找；prior表示上一层级的标识符。level 伪列（关键字）这个必须配合connect by使用。connect_by_root显示根节点列。
Oracle递归查询
hyyyer
01-21 150
创建表 建表语句： 复制代码 CREATE TABLE SC_DISTRICT ( ID NUMBER(10) NOT NULL, PARENT_ID NUMBER(10), NAME VARCHAR2(255 BYTE) NOT NULL ); ALTER TABLE SC_...
Oracle递归树形结构查询功能
09-09
Oracle数据库在处理树形结构数据时提供了强大的递归查询功能，这种特性对于组织结构、产品分类、层级菜单等场景的应用非常广泛。递归树形结构查询主要依赖于`CONNECT BY`和`PRIOR`关键字，它们允许我们构建复杂的...
oracle-递归查询地区名称
02-06
oracle 递归调用 地区 ，用到的方法是 SYS_CONNECT_BY_PATH，可以扩展层级 名称
pl/sql树操作
zhouminchinahz的博客
10-30 119
connect by 是结构化查询中用到的，其基本语法是： select ... from tablename start with cond1 connect by cond2 where cond3; 简单说来是将一个树状结构存储在一张表里，比如一个表中存在两个字段: id,parentid那么通过表示每一条记录的parent是谁，就可以形成一个树状结构。 用上述语法的查询可以取得...
oracle 加条件 向上递归查询_Oracle递归查询的几种方法
weixin_28937805的博客
01-28 2616
第一种：start with 子节点ID=‘...‘ connect by prior 子节点ID = 父节点ID1select * from mdm_organization o start with o.org_code=‘10000008‘ connect by prior o.org_code=o.org_parent_code按照条件org_code=‘10000008‘，对‘10000...
Oracle实现递归查询
Beyourselfsun的博客
11-23 330
Oracle的递归查询
Oracle递归查询树形数据
weixin_40017062的博客
11-02 5056
start with connect by prior递归查询 1、start with 子句：遍历起始条件。 2、connect by prior 子句：连接条件。 3、order by 子句：排序。
oracle递归查询
07-27
Oracle递归查询是一种查询技术，用于查询表中的层次结构数据，例如查询某个节点的父节点或子节点。在Oracle中，可以使用start with connect by prior或with递归查询来实现递归查询。 使用start with connect by ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值