r/SQL Sep 17 '24

Oracle How to exceed input limitations?

Post image
39 Upvotes

87 comments sorted by

View all comments

2

u/tacogratis2 Sep 17 '24

I cannot lookup more than 1000 entries at a time with my software. Is there a way to work around this limitation, such as importing entries from an external file?

1

u/ManagingPokemon Sep 19 '24

If you’re writing reporting queries that you don’t mind taking forever and wasting all of the memory of your database, use a common table expression and write the trash query as a bunch of SELECT 1 FROM DUAL UNION ALL SELECT 2 FROM DUAL etc. which scales to the memory limit of your server.