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!

utl_i18n special character

user7404990Aug 13 2009 — edited Aug 13 2009
SELECT utl_i18n.unescape_reference(''','US7ASCII')unescaped  FROM dual;

this is not giving the result what i want.
I want to  replace the "&apos" with    character '. 
am i missing anything here? any alternative methods?
Thanks.
This post has been answered by MichaelS on Aug 13 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2009
Added on Aug 13 2009
1 comment
967 views