select departId,parentId
FROM "SSJJ_IACENTER". T_IA_DEPARTMENT
start with departId='013001'
connect by prior parentId=departId;
递归查询 获得当前部门下所有上级部门ID集合
最新推荐文章于 2023-11-09 09:28:42 发布
select departId,parentId
FROM "SSJJ_IACENTER". T_IA_DEPARTMENT
start with departId='013001'
connect by prior parentId=departId;