Skip to Main Content

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.

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

harrrySep 11 2009 — edited Jun 17 2010
Hi

when ever values specified for 'IN' operator in select statement exceeds 1000 then I am getting this error.
How to over come this problem?
my query is like.....

select itemid from item where itemid in (1,2,3,...........) which is executing fine in Sqlserver 2005.


thanks,
harry
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2010
Added on Sep 11 2009
22 comments
84,707 views