create table tt(name varchar2(20));
insert into tt values('nihao@qq.com')
insert into tt values('niha1@qq.com')
insert into tt values('niha2@qq.com')
insert into tt values('niha3@qq.com')
insert into tt values('nihao@qq.com')
insert into tt values('niha1@qq.com')
insert into tt values('niha2@qq.com')
insert into tt values('niha3@qq.com')
commit;
select * from tt;update tt t1 set t1.name=replace((select name from tt t2 where t2.name=t1.name),'qq.com','163.com');
commit;
select * from tt;