/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

1 vote379 views1 answer
Altrer name column postgres
SQL
3 votes343 views2 answers
Truncate all tables
SQL
-1 vote419 views1 answer
How to Activate the database
SQL
0 vote342 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote349 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote331 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
1 vote332 views1 answer
Mysql get character set
SQL
2 votes338 views1 answer
Wait delay in sql server
SQL
1 vote344 views1 answer
Oracle activate job
SQL
0 vote345 views1 answer
How to close external sql connection in laravel
SQL