I want to replace all the non alphanumeric characters with 0 in a given string. Could any one help me with it? I can use function "replace" to replace a certain sign ( for example '+' )
with 0. But how could I find all the non alphanumeric characters once? Is there a Oracle function for this?
TRANSLATE returns char with all occurrences of each character in from_string replaced by its corresponding character in to_string. Characters in char that
are not in from_string are not replaced. The argument from_string can contain more characters than to_string. In this case, the extra characters at the end
of from_string have no corresponding characters in to_string. If these extra characters appear in char, they are removed from the return value.