我有一个包含多个连接和listagg的查询,如下所示; select c.case_id caseId, c.last_name lastName, c.first_name firstName,listagg(lkp_cs.descr,',') within group (order by lkp_cs.id) as caseStatus on c.ATL = lkp_alt.id
joincase<
在Oracle中,可以使用XMLAGG而不是LISTAGG来解决这个问题,当结果文本对于VARCHAR2来说太大时(错误消息:ORA-01489 Result of string concat is tooSQL示例:解决办法
RTRIM(XMLAGG(XMLELEMENT(e, MY_TEXT_SNIPPET,'').EXTRACT('/