Oracle Forms

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!

upside question marks to standard apostrophe.

user10991018Jun 22 2011 — edited Jun 22 2011

Hi
in my application i have clob text field with some big text in it. but when ever there is single apostrophe is inserted that is converted to Upside Down Question Mark
now I have 252 rows of that kind in only one table.

how to write a single query to update the chr(191) in a field CLOB datatype to standard apostorphe chr(39)

please advice.
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 20 2011

Added on Jun 22 2011

#forms, #moved-from-devops

3 comments

1,815 views