网站首页
编程语言
数据库
系统相关
其他分享
编程问答
LPAD
2024-10-26
ORA-01489: result of string concatenation is too long
https://www.cnblogs.com/ShineTan/p/3298645.htmlSELECTLPAD('x',4000,'x')||LPAD('x',4000,'x')FROMDUAL;修改为:SELECTTO_CLOB(LPAD('x',4000,'x'))||LPAD('x',4000,'x')