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