在数据库中替换部分文字

例子：
$~6OXP$c:m4W_/@;Q8x0create table test
2BN4@7oHE%~'@0(name varchar2(100));
g#RXZuX~l0insert into test values ('张三和张三李四');
9@8Mc6C%_2E[6J0insert into test values ('张三张三张山李四');
(W v(Blof'Q#Z%P0insert into test values ('张山李四');51Testing软件测试网]9BYUjgU;`7r

/i"HXe7A0SQL> select * from test;

NAME51Testing软件测试网*d2d3L Q6zv
--------------------------------------------------------------------------------
"RZ*Dc0Q:MEYs0张三和张三李四
0L$U#vOG-@.?0张三和张三李四
c(KN/Q J0张三张三张山李四
!n`!q6ya8B+V0张山李四

SQL> update test set name = REPLACE ( name ,'张三','wang');51Testing软件测试网n|2o[T;p&B_HN

&P T$Hd-yz1V04 rows updated.51Testing软件测试网 |M&b)e)F7i6}

8[&f*hbPu g0SQL> select * from test;

&H9se.E4} Q$F0NAME
Fm}2{#OU }1e0--------------------------------------------------------------------------------
(T0|/J(f[?D oA0wang和wang李四
bks"w.u(O!gY0wang和wang李四51Testing软件测试网7Rf` f%XN
wangwang张山李四
@!MU7v TN~w'r[7G0张山李四