oracle sql how to overcome 999 limit for in

Solutions on MaxInterview for oracle sql how to overcome 999 limit for in by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "oracle sql how to overcome 999 limit for in"
Violette
31 Jun 2016
1select column_X, ... from my_table
2where ('magic', column_X ) in (
3        ('magic', 1),
4        ('magic', 2),
5        ('magic', 3),
6        ('magic', 4),
7             ...
8        ('magic', 99999)
9    ) ...
10
similar questions