oracle 查询某个字段超长报错的解决方案 ORA-24920: column size too large for client

select TRIM(',' from XMLAGG(XMLELEMENT(E, 要查询的超长字段名 || ',')).EXTRACT('//text()').getclobval()) 别名 from SYS_TEMPLATE where enterpriseid = 18 and id = -3;

posted @ 2024-08-14 10:19  咧嘴玩手机的猫  阅读(385)  评论(0)    收藏  举报