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