oracle10g聚集函数,单列多行合并
从来不写笔记，最近发现越来越健忘，特此记录一下备查
单列数据多行合并为一行的oracle sql:

SELECT wmsys.wm_concat (t.id) as result FROM test t
结果：
0001ZS1000000001B739,0001ZS1000000001B72S,0001ZS1000000001B72T

树形数据层次展现

11AAA
22BBB1
31ABC
43CCC1
52DDD1
621AVC2

select id, sys_connect_by_path(id, '/')
from test
start with pid is null
CONNECT BY prior id = pid

结果：
11/1
22/1/2
321/1/2/21
43/1/3
52/1/2
621/1/2/21
71/1
82/1/2
921/1/2/21
103/1/3
112/1/2
1221/1/2/21