Skip to Main Content

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
Post Details
Added on Sep 11 2009
22 comments
79,603 views