17,382
社区成员




--如果位置不固定的话,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'