遍历此节点到祖先节点：
select * from tree t connect by prior t.parent= t.child start with t.child=‘001190360‘
遍历此节点到孙子节点：
select * from tree t connect by priort.child =t.parent start with t.child=‘001190360‘
原文：http://www.cnblogs.com/argus-agent/p/5799772.html