作者：纤妍内衣天旺店 | 来源：互联网 | 2014-07-09 16:02
sys_connect_by_path函数用法sys_connect_by_path函数是用来返回组成层级的直到当前行的值。例如：www.2cto.comSql代码select*from(selectltrim(sys_connect_by_path(id,','),',
sys_connect_by_path函数用法
sys_connect_by_path函数是用来返回组成层级的直到当前行的值。
例如：
www.2cto.com
Sql代码
select *
from (select ltrim(sys_connect_by_path(id, &＃39;,&＃39;), &＃39;,&＃39;) id,
ltrim(sys_connect_by_path(name, &＃39;,&＃39;), &＃39;,&＃39;) name,
level as lvl,
lpad(&＃39; &＃39;, 2 * (level - 1)) || id,
lpad(&＃39; &＃39;, 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 isleaf
from table_name c
start with id = 0
connect by prior c.id = c.parent_id)
where isleaf = 1;
京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有