用一句sql,查询出一个表里一列的所有内容,并拼接起来。
比如:
表 a
column1 column2
-------------------
aaa bbbb
aaa2 bbb2
aaa3 bbb3在执行了那个sql之后,结果集里只有一条数据就是aaa/aaa2/aaa3 bbbb/bbb2/bbb3
比如:
表 a
column1 column2
-------------------
aaa bbbb
aaa2 bbb2
aaa3 bbb3在执行了那个sql之后,结果集里只有一条数据就是aaa/aaa2/aaa3 bbbb/bbb2/bbb3
replace(wmsys.wm_concat(b),',','/')
from a
10G以下select substr(max(sys_connect_by_path(a,'/')),2) a,
str(max(sys_connect_by_path(b,'/')),2) b
from (select a.*,rownum rn from a )
start with rn=1
connect by rn-1=prior rn
substr(max(sys_connect_by_path(b,'/')),2) b
from (select a.*,rownum rn from a )
start with rn=1
connect by rn-1=prior rn