oracle拼接子查询返回的多个结果

使用wmsys.wm_concat函数来进行拼接

实例如下:

SELECT to_char(wmsys.wm_concat(to_char(sub.SUBSPCL_CD ))) FROM META.SUBSPCL sub,EMR.INVITEE inv WHERE inv.SUBSPCL_UUID = sub.SUBSPCL_UUID AND sub.DEFUN_IND = ‘0‘ AND inv.DEFUN_IND = ‘0‘ AND inv.SUBJ_ID = cslt.CSLT_ID

相关推荐