I've been using rlwrap for years with Oracle's sqlplus command line client on Linux.
Because it uses readline, it can benefit from settings in ~/.inputrc, along with all of your other readline-based applications for a more uniform experience.
For example, I'm a vi(m) user, so I put this in my .inputrc:
set editing-mode vi
That's just the tip of the iceberg.
These days, I tend to use the dbext vim extension for Oracle queries, allowing me to develop and save them in one file per project. But when I need to fire off something quick on the command line, it's nice to have rlwrap available.
Comments
I've been using rlwrap for years with Oracle's sqlplus command line client on Linux.
Because it uses readline, it can benefit from settings in ~/.inputrc, along with all of your other readline-based applications for a more uniform experience.
For example, I'm a vi(m) user, so I put this in my .inputrc:
That's just the tip of the iceberg.These days, I tend to use the dbext vim extension for Oracle queries, allowing me to develop and save them in one file per project. But when I need to fire off something quick on the command line, it's nice to have rlwrap available.
The command line SQL client is one place Postgres blows away Oracle. I'd pay real money for psql on Oracle.
You would have to, wouldn't you? It's Oracle...
Not at all. There are several free open source alternatives to sqlplus like Yasql and sqlpython but none of them are as good as psql.