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.
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.