Oracle 循环查询

select * from sys_department
start with departmentid =  '0303e461-2454-4d5a-bfea-2cd5a4c064c6' 
  connect by prior departmentid = parentid 
原文地址:https://www.cnblogs.com/vinsonLu/p/8508038.html