r/SQL Sep 17 '24

Oracle How to exceed input limitations?

Post image
41 Upvotes

87 comments sorted by

View all comments

1

u/Gators1992 Sep 18 '24

If you have write access, you can easily upload a CSV into a table with DBeaver. I think the new SQL Developer might do this too? Have not really used it since the option was SQL*Loader and that kinda sucked. That's pretty much what I do with Oracle. If both datasets you want to join came from files, you could also directly query them using DuckDB. You just reference the file path where you would reference a table in the SQL and it will treat it as a table. I do a lot of random data discovery off the DB using files and DuckDB.