I can’t believe SQL*Plus has survived for 5 minutes, let alone decades. And for some other equally unanswerable reason, free replacements are hard to come by. Toad is the most popular, but it’s this so-called “freeware” that expires every month.
Anyway, I think I’ve found an open-source tool with a past, and hopefully a future. Eclipse has a plugin called SQLExplorer that uses JDBC to connect to Oracle databases.
UPDATE: This seems to be still alive, I updated it today to version 3.5.0RC2. I had to download the plugin from sourceforge, extract to the Eclipse 3.3 directory, then re-set up the Oracle drivers, as detailed below…
(continued…)