Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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

708078Sep 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
83,102 views