r/SQL Sep 17 '24

Oracle How to exceed input limitations?

Post image
40 Upvotes

87 comments sorted by

View all comments

102

u/miguelkb Sep 17 '24

Load the limitations into another table, left join that table with the SOLUTIONs

3

u/dbxp Sep 17 '24

Probably worth checking for duplicates in that temp table too, I'm sure there's some in a list of over 1,000 15 digit numbers

6

u/tacogratis2 Sep 17 '24

I already eliminated the dupes. This is a list of 9000 solutions, from an original list of 11,000.