mercredi 8 septembre 2010

SQLPLUS command history

I was using sqlplus on Linux and needed command history. I looked around the net and found rlwrap.

To my surprise, it was even in Debian's apt repositories!

$ sudo apt-get install rlwrap

worked like a charm.

To use the program:

$ rlwrap sqlplus scott/tiger@orcl

I finally went for gqlplus, beacuse it is even better; it has table name completion, like the bash shell does for files & folders. It needs libncurses-dev. You should read the readme, do not perform make install, just copy the gqlplus binary into your path. Note that sqlplus must be on the path as well.

I created an alias named sqlplus that runs gqlplus.

Aucun commentaire: