How to change partial column value in a table

[Veetri]

I want to change the partial value of a column in a table using SQLPLUS. For example, I want to replace <fname>.<lname>@domain.com to <fname>.<lname>@newdomain.com. I want the sql to go through the table and replace just the domaan part of the email column. Is this possible to do with a sqlplus command? Thanks.

[nukala ramji]

hi,
i understood ur query.
the solution for this query is just by using the string functions ,we can achive the goal.

here is the solution for your query....

UPDATE tab_name SET email = substr(email,1,instr(email,'@',1,1)-1)||'@ur_newdomain.com'

in above query tab_name --> table name
email ----> column name.
i think it can help u.
do u have doubts in the above query ....feel free to mail me at ramamohan.nukala@gmail.com

[Veetri]

Thank you. I did use almost the same command before but had an extra || at the end. Anyway, the command you had worked great. Thanks again.