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
相关推荐
lynjay 2020-06-14
88384957 2020-06-12
zuihaobushi 2020-04-30
xiaohouye 2020-04-20
菇星獨行 2020-04-20
qscool 2020-04-16
Joymine 2020-03-04
CosEmon 2020-03-01
GoatSucker 2020-02-15
Joymine 2020-02-11
twater000 2020-02-01
韩学敏 2019-12-28
retacnyue 2020-01-10
KilluaZoldyck 2020-01-01
czsay 2019-12-31
qingsongzdq 2019-12-30
MFCJCK 2019-12-30
christinzhm 2010-04-29
Rafema 2011-02-13