Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Removing Non-alphanumeric characters

J.KiechleFeb 19 2008 — edited Feb 19 2008
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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2008
Added on Feb 19 2008
3 comments
11,486 views