Even if this thread is old is the first on Google, so I’ll post an Oracle equivalent to the function implemented here, using regular expressions.
Is fairly faster than nested replace(), and much cleaner.
To replace strings ‘a’,’b’,’c’ with ‘d’ in a string column from a given table
select regexp_replace(string_col,'a|b|c','d') from given_table
It is nothing else than a regular expression for several static patterns with ‘or’ operator.
Beware of regexp special characters!