Question

如何将Oracle中同一列的多行记录拼接成一个字符串

Answer 1

select tableid,wm_concat(to_char(storagename))  ,wm_concat(to_char(cnname)) from T_ORIGINFIELD t where t.issearch=1  group by tableid;