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!

Replacing Special Characters With Its Actual Value

user10088255Feb 6 2013 — edited Feb 6 2013

Hi All,

Does anyone has any idea how to replace an extended character (ASCII value ranging from 128 to 255) to its actual character set in SQL/PLSQL?

For example: “½” needs to be replaced to “1/2”
“¼” needs to be replaced to “1/4”

Ultimately if the value is “California 71 ½ ” then the result should be “California 71 1/2”.

Thanks for your time!

Regards,

This post has been answered by odie_63 on Feb 6 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2013

Added on Feb 6 2013

#11g, #plsql, #sql

3 comments

584 views