SQL多行查询结果拼接

1.Orcal

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

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

案例：

SELECT t.*, b.name
FROM t_zgdx_hyfz t
	LEFT JOIN (
		SELECT t.fid, to_char(wmsys.wm_concat(to_char(t3.name))) AS name
		FROM t_zgdx_hyfz t, t_zgdx_hyfz_user t2, t_user_info t3
		WHERE (t.modify_flag <> 'D'
			AND t2.hyfz_id = t.fid
			AND t2.user_id = t3.pid)
		GROUP BY t.fid
	) b
	ON b.fid = t.fid;