July 19, 2011 at 6:32 am
create table emp(email varchar2(20),ename varchar2(20))
insert into emp values(sree@abc.com,gfjad)
insert into emp values(and.yjpo@abc.com,uiop)
select * from emp
o/p:
email ename
sree@gmail.com gfjad
and.yjpo@gmail.com uiop
Thanks in Advance
July 19, 2011 at 6:35 am
It's not really clear what your question is, but I think you need to use the REPLACE function.
John
July 19, 2011 at 12:06 pm
Make sure you're in compliance with CAN-SPAM too. "Correcting" an email address on behalf of the person who provided the data after it's been collected and the person is no longer involved in the process can be viewed as a violation.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 19, 2011 at 12:10 pm
select replace(email, '@abc.com', '@gmail.com') as Email, Ename from #emp
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply