17,377
社区成员
发帖
与我相关
我的任务
分享
--如果位置不固定的话,replace函数简洁,如果情况很复杂,用正则不错
update t set object_id = regexp_replace(object_id,'-002-','-123-');
update tb set object_id=replace(object_id,'-002-','-123-')
update table t set t.object_id=substr(t.object_id,1,3)||'123'||substr(t.object_id,7)
where substr(t.object_id,4,3)='002'
update table t set t.object_id=substr(t.object_id,1,3)||'123'||substr(t.object_id,7)
where t.object_id='10-002-2010-2135'