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!

inserting records that contain an apostrophe

766420Apr 28 2010 — edited Apr 28 2010
Hello all,
I'm trying to insert names that have an apostrophe into my table. This is what I have now, but I'm stuck on the problem:
Update Name
set last='O'Leary' where id=4;

I know I can't write it as O'Leary but I don't know what to replace it with. For some reason I couldn't find the answer in a web search. Any ideas?

Thank you!
This post has been answered by Centinul on Apr 28 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 26 2010
Added on Apr 28 2010
5 comments
1,081 views