select repalce(wm_concat(a||b||c),',','')) from table;
--wm_concat简单一点,只能用在10g及以上的版本 --sys_connect_by_path函数通用一点,9i,10g都能用 with test as( select 1 id, 'a' A, 'b' B, 'c' C from dual union all select 2 id, 'd' A, 'e' B, 'f' C from dual union all select 3 id, 'g' A, 'h' B, 'i' C from dual) select max(replace(sys_connect_by_path(a || b || c, ','), ',')) str from test connect by prior id = id - 1 start with id = 1;
--sys_connect_by_path函数通用一点,9i,10g都能用
with test as(
select 1 id, 'a' A, 'b' B, 'c' C from dual union all
select 2 id, 'd' A, 'e' B, 'f' C from dual union all
select 3 id, 'g' A, 'h' B, 'i' C from dual)
select max(replace(sys_connect_by_path(a || b || c, ','), ',')) str
from test
connect by prior id = id - 1
start with id = 1;