在数据库中替换部分文字

例子：51Testing软件测试网8qw} Y g*R3TH
create table test51Testing软件测试网5^*p`:o8cn wX
(name varchar2(100));51Testing软件测试网]&\'PCy
insert into test values ('张三和张三李四');
p6G ? M$Q{+N0insert into test values ('张三张三张山李四');
!rI[#\tP4S5d{0insert into test values ('张山李四');51Testing软件测试网&Cy n_ X

SQL> select * from test;

NAME51Testing软件测试网0I3C:Q;Cu/GI.A
--------------------------------------------------------------------------------51Testing软件测试网^g,Fvf4Ci
张三和张三李四51Testing软件测试网W6a`/w6}r
张三和张三李四51Testing软件测试网8xD&T$Z:v;S
张三张三张山李四
;H|
B@N,E9S0张山李四51Testing软件测试网8E:^0{dT+sx}z

%^.n;^5R_AW.{L0SQL> update test set name = REPLACE ( name ,'张三','wang');51Testing软件测试网4Ey;lczW
ci

4 rows updated.

4?-H7n;zQRG0SQL> select * from test;51Testing软件测试网)lsl*i*JmfZ

/^9@3o8qylK3x0NAME51Testing软件测试网9qv1?d3q,L;| m
--------------------------------------------------------------------------------
4_9X
\'D,z)i0wang和wang李四51Testing软件测试网0i%}m(A:}
wang和wang李四
+h8N}Hv-t{0wangwang张山李四
4Tya[!u*V1LB0张山李四51Testing软件测试网~:Q
eCk