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!

We are getting below error when we have more than 1000 values in the In clause.. ORA-01795 maximum

user7716856Aug 5 2014 — edited Aug 6 2014

We are getting below error when we have more than 1000 values in the In clause..

ORA-01795 maximum number of expressions in a list is 1000

Does Oracle support more than 1000 values in latest Database versions ?

Is there are any workaround with out actually changing to code to split to less than 1000 values ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2014

Added on Aug 5 2014

6 comments

940 views