Removing Non-alphanumeric characters
I want to create a function which would take a character string as the input and removes any non-alphanumberic character(like < , >, / , ; , @ , $ ,..) ie. anything other than A to Z and 0 to 9 and return the Alpha-numeric string. Is there any Oracle pre-defined function to do this?