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)
Written by Dorin Moise (Published articles: 287)
- Likes (0)
-
Share
- Comments (0)