刚开始的
listagg(name,',') within GROUP (order by bsm) as name_new :获取的 name_new 乱码了。
处理方式: 加上 to_char,就可以解决
listagg(to_char(name),',') within GROUP (order by bsm) as name_new
刚开始的
listagg(name,',') within GROUP (order by bsm) as name_new :获取的 name_new 乱码了。
处理方式: 加上 to_char,就可以解决
listagg(to_char(name),',') within GROUP (order by bsm) as name_new