在数据库中替换部分文字

例子：
;pYqs:zR J0create table test
6b I%N3O;bLn,c{0(name varchar2(100));51Testing软件测试网:}W^xb r j a_gW
insert into test values ('张三和张三李四');51Testing软件测试网'pu?!s{_]
insert into test values ('张三张三张山李四');
XO9]5u!WmTa$b0insert into test values ('张山李四');

H,x&n%W/b j%W
Cx0SQL> select * from test;51Testing软件测试网Q.A!\(C ~\qv

NAME
;X}reiV!?fN g0--------------------------------------------------------------------------------51Testing软件测试网y6@x){Z5H
张三和张三李四51Testing软件测试网wH0?8~vc{
张三和张三李四
^e5k1w2\]+s0张三张三张山李四51Testing软件测试网e_Z;O"P#kM
张山李四51Testing软件测试网Yucj3j @P]R

L,E!]7A1L^"?0SQL> update test set name = REPLACE ( name ,'张三','wang');

4QGG8~e2zWhp04 rows updated.51Testing软件测试网4e-h
o$VW#hZ#e
q5]"B,u

SQL> select * from test;

t/} h6]in
E0NAME
8W1Vv#Js"Hl*|0NW0--------------------------------------------------------------------------------
5Y~cd_Di~
` Cb{0wang和wang李四51Testing软件测试网`#zNwwg \
wang和wang李四
(Wh@X#f(yY(f0wangwang张山李四51Testing软件测试网bJ%AQr/o;`
张山李四51Testing软件测试网Q eIia J%H q:Rp