oracle 11g 树形结构java代码以及结果是本文探讨的主要内容。
一、start with org_id = '条件1' prior parent_id = son_id; 的作用
这个就是为了把树形结构全部查出来,树的目录就放在同一张表中,如
1
|--2
|--3
|--4
|--5
|--6
|--7
|--8
|--9
|--10
这样的结构怎么查出来呢,这种特殊的查询,connect by perior就派上用场了 。
二、代码
Java代码 <javascript:void()>
1. create table TESTTEMP
2. (
3. parent_ID VARCHAR2(30),
4. son_ID VARCHAR2(30)
5. );
6.
7. insert into TESTTEMP values('1','0');
8. insert into TESTTEMP values('1','2');
9. insert into TESTTEMP values('1','3');
10. insert into TESTTEMP values('1','4');
11. insert into TESTTEMP values('1','7');
12. insert into TESTTEMP values('4','5');
13. insert into TESTTEMP values('5','6');
14. insert into TESTTEMP values('7','8');
15. insert into TESTTEMP values('8','9');
16. insert into TESTTEMP values('9','10');
17. commit;
18. select * from TESTTEMP
19. start with parent_ID='1'
20. connect by parent_ID= prior son_ID
create table TESTTEMP
(
parent_ID VARCHAR2(30),
son_ID VARCHAR2(30)
);
insert into TESTTEMP values('1','0');
insert into TESTTEMP values('1','2');
insert into TESTTEMP values('1','3');
insert into TESTTEMP values('1','4');
insert into TESTTEMP values('1','7');
insert into TESTTEMP values('4','5');
insert into TESTTEMP values('5','6');
insert into TESTTEMP values('7','8');
insert into TESTTEMP values('8','9');
insert into TESTTEMP values('9','10');
commit;
select * from TESTTEMP
start with parent_ID='1'
connect by parent_ID= prior son_ID
结果:
1 0
1 2
1 3
1 4
4 5
5 6
1 7
7 8
8 9
9 10
转载于:https://blog.51cto.com/19880614/1045392