Friday, October 12, 2007

Oracle problem

I got one new funda today.....

oracle does not support query with IN clause having more than 1000 ids in it.
It gives exception.

ex : select * from employee where emp_id in ('E001','E002','E003'... utpo 1000)