Hello,

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?

Thanks.