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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,517 views