从上往下推,获得所有子。
select *
from (select unit_id, unit_name, parent_unit, LEVEL le
from UNIT
Start With unit_id = '1'
Connect By Prior unit_id = parent_unit)
where unit_id != '1'
从下往上推,获得所有父。
select *
from (select unit_id, unit_name, parent_unit , LEVEL le
from UNIT
Start With unit_id = '9'
Connect By Prior parent_unit=unit_id)
where unit_id != '9'