DevOps, CI/CD and Automation

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 put more than 1000 values into an Oracle IN clause

Sreenivas NJan 31 2013 — edited Feb 18 2013

Is there any way to get around the Oracle 10g limitation of 1000 items in a static IN clause? I have a comma delimited list of many of IDs that I want to use in an IN clause, Most of the times values may exceed 5000. And I don't have privileges to create a temporary table, so that I can put all those in that and run at a time.

Thanks
Sreenivas

This post has been answered by asahide on Jan 31 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 18 2013

Added on Jan 31 2013

#oracle-call-interface-oci

2 comments

3,405 views