--从根到叶子查询
select
t.organization_name,
t.id,
t.parent_organization_id,
level lev,
t.serial_num,
CONNECT_BY_ROOT t.organization_name rootname,
SYS_CONNECT_BY_PATH (t.ID, '/') || '/' PATH,
connect_by_isleaf
from
t_pdc_organization t
where
t.delete_flag = '0'
start with t.id = '0'
connect by t.parent_organization_id = prior t.id
order siblings by t.serial_num;
--从叶子到根节点查询
select
t.organization_name,
t.id,t.parent_organization_id,
level lev,
t.serial_num,
CONNECT_BY_ROOT t.organization_name rootname,
SYS_CONNECT_BY_PATH (t.ID, '/') || '/' PATH,connect_by_isleaf
from
t_pdc_organization t
where
t.delete_flag='0'
start with t.id='1142320'
connect by prior t.parent_organization_id = t.id
order siblings by t.serial_num