从子节点查根节点
select m.N_ID, m.c_name
from T_DEPARTMENT m
start with m.N_ID=参数
connect by m.n_id=prior m.N_PARENT_ID ;
从根节点查子节点
select m.N_ID, m.c_name
from T_DEPARTMENT m
start with m.N_ID=参数
connect by m.N_PARENT_ID=prior m.N_ID ;
select m.N_ID, m.c_name
from T_DEPARTMENT m
start with m.N_ID=参数
connect by m.n_id=prior m.N_PARENT_ID ;
从根节点查子节点
select m.N_ID, m.c_name
from T_DEPARTMENT m
start with m.N_ID=参数
connect by m.N_PARENT_ID=prior m.N_ID ;