Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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 by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #oracle #sql #overcome #limit #IN
ADD COMMENT
Topic
Name
6+9 =