connect by prior 应用总结

connect by prior 使用总结

SELECT * FROM CATEGORY c CONNECT BY PRIOR c.category_parent_id = c.id  START WITH c.id = 123

?上面的sql查询是 123 父结点的结果集。