本文介绍了一个使用SQL查询来获取特定组织结构的方法。通过一个具体的例子展示了如何从组织名称出发，利用START WITH和CONNECT BY PRIOR子句递归地查询整个组织架构。
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
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;
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
