Answers for "oracle sql how to overcome 999 limit for IN"

SQL
0

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)
    ) ...
Posted by: Guest on September-09-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language