Hello,
I need to update the sales@test.com to salesteam@test.com using UPDATE.is there any way to use a script to update as a whole instead of doing one by one update.
Below are scenarios:
create table test_tab_dump
(
code varchar2(10),
attribute7 varchar2(150));
insert into test_tab_dump values('0001','test@abc.com;sdf@abc.com;sales@test.com;tyu@abc.com');
insert into test_tab_dump values ('0002','test4@abc.com;sdf@abc.com;sales@test.com;fgh@abc.com');
insert into test_tab_dump values ('0003','test2@abc.com;sdf@abc.com;sales@test.com;kjl@abc.com');
insert into test_tab_dump values ('0004','test1@abc.com;sdf@abc.com;sales@test.com;wer@abc.com');
commit;