天天看点

oracle listagg too long字符显示太长

修改后

xmlagg(xmlparse(content a.QUOTA_NAME||',' wellformed) order by a.ARCHITECTURE_ID).getclobval() as employees
           

修改前

LISTAGG( to_char(a.QUOTA_NAME), ',') WITHIN GROUP(ORDER BY a.ARCHITECTURE_ID) AS employees