oracle树查询

--向下一个级别
SELECT * FROM T_PUB_MKXX  o  WHERE o.n_xtdm =9 and o.n_sjmk in(1);

--向下遍历整棵树，可以指定parentid，来遍历指定parentid节点的树，不包含parentid 
select * 
from T_PUB_MKXX  where n_xtdm =9
start with n_sjmk = '1' 
connect by prior n_mkdm = n_sjmk