ORACLE LISTAGG 乱码问题

问题描述：使用listagg列合并为字符串，结果乱码

解决办法：

把LISTAGG的内容先用TO_CAHR转为字符串即可

SELECT LISTAGG(TO_CHAR(NAME),',') WITHIN GROUP (ORDER BY NAME) as NAME FROM TABLE_NAME;