oracl 权限循环查询

select * from SYS_ROLE_LIST start with parentid = 0 connect by prior id = parentid

  

原文地址:https://www.cnblogs.com/Iyce/p/3910512.html