/SQL/Oracle sql how to overcome 999 limit for IN

Oracle sql how to overcome 999 limit for IN

select column_X, ... from my_table
where ('magic', column_X ) in (
        ('magic', 1),
        ('magic', 2),
        ('magic', 3),
        ('magic', 4),
             ...
        ('magic', 99999)
    ) ...

Source: stackoverflow.com

Similar codes

31 votes353 views4 answers
Mysql grant execute
SQL
0 vote281 views0 answer
How to connect to datbase in springboot
SQL
0 vote359 views1 answer
SQL Server date literal
SQL
0 vote345 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
1 vote356 views1 answer
Mysql drop key
SQL
1 vote321 views1 answer
Mysql server does not start mac
SQL
0 vote365 views1 answer
Date datatype in livesql
SQL
5 votes346 views1 answer
Minecraft java port number
SQL
0 vote332 views1 answer
Mysql cdn link
SQL
0 vote368 views1 answer
Influxdb list all tags for a measurement
SQL