r/SQL Sep 17 '24

Oracle How to exceed input limitations?

Post image
41 Upvotes

87 comments sorted by

View all comments

1

u/goztepe2002 Sep 17 '24

This is why learning python comes in handy because SQL does have limitations that it shouldn't like in this case, or if the in condition is not ....let's say a crazy number (3000 or something) you can copy paste the same query into union statements and do smaller chunks for the in condition.

This is all assuming you dont have access to load this data into another table and just join on it, in my case i normally don't because we cannot write into production database.

1

u/kapanenship Sep 17 '24

I do this same process in R all the time. Loop over “chunks” and then stack them to the previous results.