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!

Escaping Single Quote character in the IN clause

814917Sep 13 2012 — edited Sep 14 2012
Hi,

I want to query a table with IN clause. The data might consist of strings with '(single Quote). So when I put the strings in the IN clause like IN('string1','string2'), the query gets corrupted in case the string consists of single quote character.

Please let me know how to escape this character.

Thanks,
Kartheek
This post has been answered by vlethakula on Sep 13 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2012
Added on Sep 13 2012
9 comments
12,647 views