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

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

标签：sys   char   函数   and   fun   har   bsp   ora   HERE