oracle递归遍历查询

CREATE TABLE TREE(    ID INTEGER    ,NAME VARCHAR2(30)    ,UP_ID INTEGER)<pre name="code" class="plain">

insert into tree values(1,'一级',8);

insert into tree values(2,'二级',1);

insert into tree values(3,'三级',2);

insert into tree values(4,'三级',6);

insert into tree values(5,'三级',2);

查询8下所有节点

select    id    ,name    ,up_idfrom treestart with up_id=8 connect by prior id=up_id

查询结果如下：

1一级82二级13三级25三级2