oracle利用“start with connect by”查询子节点和父节点数据显示为树状形,此处根节点的pid为null,请根据实际字段值设置进行查询
select id, pid, name from sys_permission start with pid is null connect by prior id=pid
注:oracle视图不适用oracle递归树查询
oracle利用“start with connect by”查询子节点和父节点数据显示为树状形,此处根节点的pid为null,请根据实际字段值设置进行查询
select id, pid, name from sys_permission start with pid is null connect by prior id=pid
注:oracle视图不适用oracle递归树查询