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