Oracle 1000 ‘in’ entries limit

Written on 6 January 2015, 01:34pm

Tagged with: ,

Problem: Oracle error maximum number of expressions in a list is 1000
Solution:


-- Instead of
select * from foo where id in (List)
-- use
select * from foo where id in (Sub-query)

link

Leave a response