Skip to Main Content
Forums

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!

How to remove special characters from string using translate() without typing all special chars?

933937Nov 11 2014 — edited Nov 12 2014

Hi All,

I am trying to remove special chars without using regular expressions.

translate(column name or string,'!@#$&*(*()_)**"":}{?>?,./,',' ')

I want to eliminate this manual process of giving all special chars by using some function like chr() or ascii().

Please show me the way.

Thanks in advance
This post has been answered by BluShadow on Nov 12 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 10 2014
Added on Nov 11 2014
12 comments
2,221 views