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!

Special Character to ASCII code conversion

Karthik.KNov 23 2011 — edited Nov 23 2011

Hi Gurus,

I'm using Oracle 11g database.

I have a requirement like, if there is any special characters in String then it needs to be converted to equivalent ASCII value(Hex) prefix with % symbol.

Ex

Test ‘Test’ - Test%20%27Test%27
Abc@xyz - Abc%40xyz

Expected Special Characters are ~,@,’,!,&,”

Can anyone provide me solution for this.

Regards,
Karthik

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2011

Added on Nov 23 2011

2 comments

1,796 views