oracle replace函数用法

update CALL_3_1_103_101 t set t.FILE_SERVER=replace(t.FILE_SERVER , '211.151.35.101' , '10.1.251.12' )

 

update ofroster t set t.jid=replace(t.jid,'as-01-001','10.1.1.106') 

 

可以加条件 
update c5_call_sheet a set a.record_file_name = replace(a.record_file_name, '/10.3.1.102/', '/10.3.1.101/') where a.account_id in ('P000000003169','Z000000003284') and a.record_file_name is not null;