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.