输入banner图图片脚本导航/分类

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