-- 查询id=100的所有父节点select * from TABLE start with id = 100 connect by nocycle prior pid = id-- 查询id=100的所有子节点select * from TABLE start with id = 100 connect by nocycle prior id = pid
本文共 251 字，大约阅读时间需要 1 分钟。
-- 查询id=100的所有父节点select * from TABLE start with id = 100 connect by nocycle prior pid = id-- 查询id=100的所有子节点select * from TABLE start with id = 100 connect by nocycle prior id = pid
转载于:https://www.cnblogs.com/jieyuefeng/archive/2013/05/10/3071280.html