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;
未经同意谢绝转载,如需转载,请联系博主
select TRIM(',' from XMLAGG(XMLELEMENT(E, 要查询的超长字段名 || ',')).EXTRACT('//text()').getclobval()) 别名 from SYS_TEMPLATE where enterpriseid = 18 and id = -3;