--找ID为**的父级记录
SELECT *
FROM [TABLE]
START WITH ID = {**}
CONNECT BY PRIOR PARENT_ID = ID;
--找ID为**的子级记录
SELECT *
FROM [TABLE]
START WITH ID = {**}
CONNECT BY PRIOR ID = PARENT_ID;
Oracle查找父子级数据
最新推荐文章于 2021-09-17 10:20:05 发布