sys_connect_by_path函数用法
sys_connect_by_path函数是用来返回组成层级的直到当前行的值。
例如：
www.2cto.com
Sql代码
select *
from (select ltrim(sys_connect_by_path(id, ','), ',') id,
ltrim(sys_connect_by_path(name, ','), ',') name,
level as lvl,
lpad(' ', 2 * (level – 1)) || id,
lpad(' ', 2 * (level – 1)) || name,
lead(level) over(order by id) leadlvlorder,
case
when (level – lead(level) over(order by id)) < 0 then
0
else
1
end isloracle账号eaf
from table_name c
start with id = 0
connect by prior c.id = c.parent_id)
where isleaf = 1;