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!

IN Clause Limitation

2847479Jan 10 2019 — edited Jan 14 2019

Is it possible to increase the amount of "IN clause" values within an sql statement from 1000 to 3000. If not what other options do I have besides doing multiple IN sql statements? Please note I am working in Oracle 12c on an Exadata RAC environment.

Added on Jan 10 2019

#sql

15 comments

3,072 views