connect by prior 使用总结
SELECT * FROM CATEGORY c CONNECT BY PRIOR c.category_parent_id = c.id START WITH c.id = 123
?上面的sql查询是 123 父结点的结果集。
发布时间： 2012-07-24 17:47:58 作者： rapoo
connect by prior 使用总结
SELECT * FROM CATEGORY c CONNECT BY PRIOR c.category_parent_id = c.id START WITH c.id = 123
?上面的sql查询是 123 父结点的结果集。