oracle 递归查询 树查询

通过根节点遍历子节点.
select level,a.deptproperty,a.*   from sys_org a 
start with a.parentid='0'
connect by prior a.org_objid=a.parentid

--通过子节点获取顶节点
select FIRST_VALUE(org_objid) OVER
(ORDER BY LEVEL DESC ROWS UNBOUNDED PRECEDING)
  AS firstdeptid from sys_org start with org_objid='3617460111308021' connect by prior parentid=org_objid