树形机构递归:
向下
select orgid from t_org o start with o.orgid='' connect by prior o.orgid=o.parentid;
向上:
select orgid from t_org o start with o.orgid='04772000' connect by prior o.parentid=o.orgid ;
oracle树结构
最新推荐文章于 2024-07-15 18:07:55 发布
树形机构递归:
向下
select orgid from t_org o start with o.orgid='' connect by prior o.orgid=o.parentid;
向上:
select orgid from t_org o start with o.orgid='04772000' connect by prior o.parentid=o.orgid ;