I had a need for an command line SQL interface for Oracle yesterday, but didn't want to dirty my shiny new Ubuntu workstation with Oracle's extremely crappy SQLPlus. Seriously Oracle, could you bring your crappy CLI into the 90's?
Anyway, that's when I discovered Hen*Plus (written by Henner Zeller, hence the play on words to get Hen*Plus). Its a great little Java program that provides power users (or really anybody not brain dead) a command line interface into Oracle or nearly any other database with a JDBC driver. And it has hooks with for libreadline, so it works great on Linux. I highly recommend it. Of course, I highly recommend anything that makes Oracle suck less... and there's a lot of room there for that type of thing.
If you are an Ubuntu user, you can get Hen*Plus with apt-get (apt-get install henplus), but be forewarned that the current Ubuntu version is way broken. The fix is easy. Get the 0.9.8 source (or later) from the link above, build it using Ant (ant jar in the directory where you untar the source). Then take the henplus.jar in the build sub-directory and copy that over the henplus.jar in /usr/share/henplus.
0 comments:
Post a Comment