ORACLE 层次查询、目录树节构查询

select level,DEPARTMENT_GUID,SUPERIOR_GUID,DEPARTMENT_NAME from risenet_department  start with superior_guid='{0A130410-0000-0000-2E32-7B6700000001}'
CONNECT BY PRIOR department_GUID=SUPERIOR_GUID

 order siblings   by tabindex

 

 

层次查询关键字

start with 列名=值 connect by prior 列名=列名

其中 prior 关键字表单是否进行深层次查询；如果不加这个关键字，将不再对下一级进行深层次查询

 order siblings   by  列名 

进行排序