update all rows such that doesn't cause duplicate
Date: Mon, 14 Dec 2009 11:51:24 -0800 (PST)
I've a oracle DB in which one of the VARCHAR2 fields that is part of the key needs to have a substring replaced with another with no special $ character in front of it.
However, when I do this replace, I notice that for a few rows, this would cause a duplicate row and hence get rejected.
So, I'd like to formulate a SQL statement such that all rows would be updated as long as it doesn't lead to duplicates.
Any pointers appreciated!
UPDATE MYTAB SET request = REPLACE(request, '$myString', 'myString') WHERE (operation='myOperation') and request like '%$myString%'; Received on Mon Dec 14 2009 - 13:51:24 CST