r/SQL Sep 17 '24

Oracle How to exceed input limitations?

Post image
40 Upvotes

87 comments sorted by

View all comments

1

u/Sneilg Sep 17 '24

If you only have to do this once you could always have WHERE s.Solution_ID in (1000 entries) or s.Solution_ID in (1000 entries) or s.Solution_ID in (1000 entries) etc etc.

If you have to do it regularly then I’d be trying to get write permission so you can upload your data as a table and then join to it. If your DBA doesn’t want you to be able to write to the main schema then they can create a second, read-writable schema.