在数据库中替换部分文字

;WJ(j5^\+ZA0例子：51Testing软件测试网 EsvNc{6\
create table test
Y ]N9Td1E0(name varchar2(100));
EAG
U9XjN0insert into test values ('张三和张三李四');
6e
_S*C,C:fD:HO0insert into test values ('张三张三张山李四');
5?*m.\$Z5}#y0insert into test values ('张山李四');51Testing软件测试网_$mjQY

Q|F*I YqW0SQL> select * from test;51Testing软件测试网\Y7me4N{%j1zw|

r^j:cX$?b0NAME51Testing软件测试网qxPsg a
--------------------------------------------------------------------------------
9]*@_0WB8?3_$la0张三和张三李四51Testing软件测试网Ms9V2v&ZH|uk
张三和张三李四
:|k}"o5L!I|0张三张三张山李四51Testing软件测试网z+C[r ~VS
张山李四51Testing软件测试网"Tk@l}tg.sAm

SQL> update test set name = REPLACE ( name ,'张三','wang');51Testing软件测试网+d'DwjPzlZ8X;Rf4d

4 rows updated.51Testing软件测试网V;BQO0[u!wO9\Ip

O#P&MH7X7C0SQL> select * from test;

c1L n;M/O7eT
V0NAME51Testing软件测试网-N^ X9B%AY
^2z
--------------------------------------------------------------------------------
c9kfN%pH0wang和wang李四51Testing软件测试网_2VN:QC3P`l7~
wang和wang李四
xM QJ ~$dw/D0wangwang张山李四
eL+B6Nd { c;{2@p0张山李四51Testing软件测试网 ]}-~arj%g ^+|