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

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

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