[b]树自关联表sql,将关系节点名称拼成字符串:[/b]
关键字prior :影响最后拼写成的path字符串,放在t.id前,则拼成的串从根->叶。放在t.parentid前,则拼成从叶->根
[b]1.从根往下查[/b]
[b]2.从子往根查[/b]
关键字prior :影响最后拼写成的path字符串,放在t.id前,则拼成的串从根->叶。放在t.parentid前,则拼成从叶->根
[b]1.从根往下查[/b]
select sys_connect_by_path(t.name, '>>') path form mytable t
where 1 = 1
start with t.parentid = 'root'
connect by prior t.id = t.prarentid
[b]2.从子往根查[/b]
select sys_connect_by_path(t.name, '>>') path form mytable t
where 1 = 1
start with t.isleaf = true
connect by prior t.id = t.prarentid