select replace(cln,'1213','1200013') from tbn where cln like '1213/%' or cln like '%/1213/%' or cln like '%/1213'
修改的话
update tbn set cln=replace(cln,'1213','1200013') where cln like '1213/%' or cln like '%/1213/%' or cln like '%/1213'
看看这样如何？强制把它变成字符串应该就不会加了。
set value to_char(substr(to_char(cln),1,2)+'000'+substr(to_char(cln),3))
set cln=to_number(substr(to_char(cln),1,2)+'000'+substr(to_char(cln),3))
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024