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

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