select instr('http://10.0.250.104:8078/luxiliangmixian/invoke','/luxiliangmixian') from dual;--25
select substr('http://10.0.250.104:8078/luxiliangmixian/invoke',instr('http://10.0.250.104:8078/luxiliangmixian/invoke','/luxiliangmixian')) from dual;--/luxiliangmixian/invoke
update ATTRIBUTEVALUEEN a set a.attributevaluestr = 'http://10.0.250.104:8078'||substr(a.attributevaluestr,instr(a.attributevaluestr,'/luxiliangmixian')) where a.attributevaluestr like '%luxiliangmixian/invoke%';
使用oracle的substr和instr更新字段的部分字符串
最新推荐文章于 2024-05-12 20:54:16 发布