SELECT *
FROM (SELECT *
FROM o_org
WHERE org_name = ‘a’) a
START WITH a.org_no = ‘b’
CONNECT BY PRIOR a.org_no = a.p_org_no;
Oracle 递归查询 start with connect by
最新推荐文章于 2023-10-24 00:30:47 发布
SELECT *
FROM (SELECT *
FROM o_org
WHERE org_name = ‘a’) a
START WITH a.org_no = ‘b’
CONNECT BY PRIOR a.org_no = a.p_org_no;