Oracle中对多行查询结果进行拼接

to_char(wmsys.wm_concat(to_char( st.col_name))) as new_name

to_char: 将当前值转换成字符串类型;
wmsys.wm_concat:拼接函数

查询出的多列结果拼接成字符串，中间用逗号分割。

例：

 select to_char(wmsys.wm_concat(to_char(t.diagnosis_desc))) as new_name
   from outp_diagnosis t
  where t.clinic_no = '2108130000049000058'