with temp as( select 1 id from dual union all select 2 id from dual union all select 3 id from dual union all select 4 id from dual union all select 5 id from dual ) select substr(wm_concat(id ||';'),1,length(wm_concat(id ||';')) - 1) from temp
如果我数据量有20条或者N跳。, 我的写 多少个 select X id from dual啊 。。 不是个办法啊。
select replace(wm_concat(id),',',';') from you_table;
select 1 id from dual
union all
select 2 id from dual
union all
select 3 id from dual
union all
select 4 id from dual
union all
select 5 id from dual
)
select substr(wm_concat(id ||';'),1,length(wm_concat(id ||';')) - 1) from temp
select replace(wm_concat(id),',',';') from you_table;