oracle中的递归查询(start with/connect by)
-- 查询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
-- 查询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