SQL> select * from mytree;ID NAME PARE
---- ---- ----
1 a 0
2 b 1
3 c 1
4 d 2
5 c 4SQL> select * from mytree
2 connect by id = prior parent
3 start with id='5';ID NAME PARE
---- ---- ----
5 c 4
4 d 2
2 b 1
1 a 0
---- ---- ----
1 a 0
2 b 1
3 c 1
4 d 2
5 c 4SQL> select * from mytree
2 connect by id = prior parent
3 start with id='5';ID NAME PARE
---- ---- ----
5 c 4
4 d 2
2 b 1
1 a 0
http://search.csdn.net/expert/topic/61/6101/2003/3/19/1551178.htm