使用oracle的substr和instr更新字段的部分字符串

 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%';