Limitation of IN clause
763899May 6 2010 — edited May 6 2010Hi Gurus,
Can't seem to find the right answer by just googling. Anyone knows how many values (and the limit) I can pass to the IN clause like the example below
select number_id from foo where number_id IN (1,2,3,4,5,6,7,...AND SO THE LIST GOES)
Will oracle be able to perform and optimize the query well if I am passing 800 or more values in the IN clause? Or should I store the data in a table or nested table then join it to the other table.
Pls advise.
rgds,
guest