Oracle递归查询树形数据实例代码（oracle 递归查询树状结构）怎么可以错过

🌐 经济型：买域名、轻量云服务器、用途：游戏网站等《腾讯云》特点：特价机便宜适合初学者用点我优惠购买

🚀 拓展型：买域名、轻量云服务器、用途：游戏网站等《阿里云》特点：中档服务器便宜域名备案事多点我优惠购买

🛡️ 稳定型：买域名、轻量云服务器、用途：游戏网站等《西部数码》特点：比上两家略贵但是稳定性超好事也少点我优惠购买

create table area_test(
id number(10) not null,
parent_id number(10),
name varchar2(255) not null
);

alter table area_test add (constraint district_pk primary key (id));

insert into area_test (ID, PARENT_ID, NAME) values (1, null, ‘中国’);
insert into area_test (ID, PARENT_ID, NAME) values (11, 1, ‘河南省’);
insert into area_test (ID, PARENT_ID, NAME) values (12, 1, ‘北京市’);
insert into area_test (ID, PARENT_ID, NAME) values (111, 11, ‘郑州市’);
insert into area_test (ID, PARENT_ID, NAME) values (112, 11, ‘平顶山市’);
insert into area_test (ID, PARENT_ID, NAME) values (113, 11, ‘洛阳市’);
insert into area_test (ID, PARENT_ID, NAME) values (114, 11, ‘新乡市’);
insert into area_test (ID, PARENT_ID, NAME) values (115, 11, ‘南阳市’);
insert into area_test (ID, PARENT_ID, NAME) values (121, 12, ‘朝阳区’);
insert into area_test (ID, PARENT_ID, NAME) values (122, 12, ‘昌平区’);
insert into area_test (ID, PARENT_ID, NAME) values (1111, 111, ‘二七区’);
insert into area_test (ID, PARENT_ID, NAME) values (1112, 111, ‘中原区’);
insert into area_test (ID, PARENT_ID, NAME) values (1113, 111, ‘新郑市’);
insert into area_test (ID, PARENT_ID, NAME) values (1114, 111, ‘经开区’);
insert into area_test (ID, PARENT_ID, NAME) values (1115, 111, ‘金水区’);
insert into area_test (ID, PARENT_ID, NAME) values (1121, 112, ‘湛河区’);
insert into area_test (ID, PARENT_ID, NAME) values (1122, 112, ‘舞钢市’);
insert into area_test (ID, PARENT_ID, NAME) values (1123, 112, ‘宝丰市’);
insert into area_test (ID, PARENT_ID, NAME) values (11221, 1122, ‘尚店镇’);