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 handle special characters in email

1567114Sep 30 2018 — edited Oct 10 2018

Hello Guru, I have some email which has special character in it.

Example :TESTXÃO@mail.com When I try to use the below syntax its coming as:

select REGEXP_REPLACE('TESTXÃO@mail.com','[^0-9A-Za-z]', '') from dual

Output showing as:

TESTXOmailcom

It should show as :TESTXO@mailcom (overcoming the special character)

Please advise
This post has been answered by 1567114 on Oct 8 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2018
Added on Sep 30 2018
32 comments
2,150 views