Oracl树查询

//从底往上找祖父节点

select id,level from T_BUSINESS_RELATION start with ID=70747 connect by prior parentid = id order by level desc

 

//从顶向下展开树节点

select level+1 nlevel,id,parentid from T_BUSINESS_RELATION start with parentid=? connect by prior ID = parentid order by id