SQL树查询

-- Create table
create table T_BUMEN
(
  t_id      VARCHAR2(200),
  t_bumen   VARCHAR2(200),
  t_fubumen VARCHAR2(200)

)

start with   connect by prior

select * from T_BUMEN tb start with tb.t_id ='6' connect by prior   tb.t_fubumen=tb.t_id;--所有父节点 

select * from T_BUMEN tb start with tb.t_fubumen ='6' connect by prior tb.t_id = tb.t_fubumen;-- 所有子节点

 SELECT * FROM T_BUMEN  aa
 WHERE
  not  EXISTS
  (
         SELECT  *  FROM  T_BUMEN   bb  WHERE aa.t_fubumen='2'
  )