sleepyy

摘要： 详细参考：http://blog.csdn.net/crazyxingjc/article/details/7756299语法：select * from table start with cond1 connect by cond2 where cond3;典型的查询方式：（1）查子节点select t.id, t.pid, t.name from t_tree t start with t.id = 100 --开始节点 connect by prior t.id = t.pid; -- id优先，向下查子节点 -- 或 connect by t.pid = prior t.... 阅读全文