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!

how to query if you have apostrophe

778580Jul 8 2010 — edited Jul 8 2010
how to query if you have value with apostrophe ' like o'reilly

select * from users where name ='o'reilly'

it throws an error

any help is much appreciated

thanks
This post has been answered by Tubby on Jul 8 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2010
Added on Jul 8 2010
4 comments
2,468 views