select listagg(name,',') within group(order by a.id)
from 目标表明 a
where 1=1
<iterate prepend="and" open="(" close=")" conjunction="or">
a.id = #rangeList[]#
<!-- rangeList是调用方法处传的参数,这里用时,后边要加上[] -->
</iterate>
</select>
select listagg(name,’,’) within group(order by a.id) from table1 a