1、创建一张测试表
create table example
(
id VARCHAR2(50) not null,
parentid VARCHAR2(50) not null,
childrenid VARCHAR2(50) not null
)
2、插入一些测试数据
insert into example values('1','1','1_1');
insert into example values('2','2','2_2');
insert into example values('3','1_1','1_1_1');
insert into example values('4','2_2','2_2_2');
insert into example values('5','1_1_1','1_1_1_1');
insert into example values('6','11','1_1');