–末级的部门判断,参考如下:
create or replace view isleafdept as
SELECT
dept.pk_dept,
dept.name,
LEVEL LVL,
--connect_by_isleaf为1时表示为末级
decode(connect_by_isleaf, 1, 'Y', 'N') IS_LEAF
FROM org_dept dept
START WITH dept.pk_fatherorg = '~'
CONNECT BY dept.pk_fatherorg = PRIOR dept.pk_dept;