Oracle查看树形数据路径:

1
2
3
4
5
select CONNECT_BY_ROOT title, --(根数据),
-- (路径)
sys_connect_by_path(title, '-->' ),level, --(层次)
start with condition
connect by parent_id = prior id