/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

0 vote338 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote296 views1 answer
Recursive query herarchical data sql server
SQL
3 votes364 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
11 votes342 views5 answers
Laravel db facade
SQL
3 votes319 views2 answers
Enter mysql command line
SQL
2 votes307 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote319 views1 answer
Less than and between in sql query
SQL
0 vote262 views0 answer
How to connect to datbase in springboot
SQL
0 vote292 views1 answer
Postgresql subquery
SQL
0 vote316 views1 answer
Sql case sttement with set
SQL