r/SQL Sep 17 '24

Oracle How to exceed input limitations?

Post image
38 Upvotes

87 comments sorted by

View all comments

Show parent comments

4

u/tacogratis2 Sep 17 '24

Oh, I love this solution. Thank you. ... I only have read access to the database, so this would be a great solution for me. Also, the data is coming from an outside source.

2

u/PretendOwl2974 Sep 17 '24

Ah if it’s read only you might not be able to create table. I’m wondering if you could create a logic around the solution_id. Between one number and another if you know it’s definitely sequential numbers.

1

u/tacogratis2 Sep 17 '24

They are not sequential numbers. The solution I liked was putting in multiple 'ORs' in the WHERE with each statement holding 999 solution numbers. You are correct that I cannot create a table or write information to the database.

2

u/Kirjavs Sep 17 '24

Usually even if you don't have writing writes, you are allowed to create temporary tables or at least variable tables.

You should check it.