ORACLE 实现字符串根据条件拼接
oracle代码
SELECT listagg(CONCAT(CONCAT(f.HOSPITAL_FIELD, '-'),h.HOSPITAL_FIELD), ',') within group ( order by CONCAT(CONCAT(f.HOSPITAL_FIELD, '-'),h.HOSPITAL_FIELD) ) AS fieldName FROM 表名称 h
LEFT JOIN 关联表名称 f ON f.ID = H.PARENT_ID
WHERE h.STATUS = 0 AND instr(#{fieldSpecial},h.ID) <>0
GROUP BY h.STATUS