sel
and when pressing the tab key rlwrap completes it to SELECT
.
Does not sound spectacular?
It isn't, anyway, but quite useful. That´s the way rlwrap can do completion on the following things:
To make it work, you have to follow those steps:
$
and #
as word delimiters - which is wrong for SQL. So I wrote a script named sql+ to repair that. It is also in each package.
You can download my extensions for three Oracle Versions:
All you have to do is: untar the package into /usr/local/share/rlwrap/completions
and put the scripts sql+
and asm+
somewhere into your path, like /usr/local/bin
. That's it.
I created rlwrap-extensions for Oracle version 9i, 10g and 11g. They differ only in view names / packages names etc in the keyword lists. Since rlwrap does not care to which Oracle version it is talking to, it does not matter to use rlwrap-extensions for a different Oracle Version.
If in doubt, take the newest version.When calling rman, adrci or asmcmd with rlwrap, use the switch -i to force rlwrap into case-insensitive mode. Just like sqlplus, those commands use case insensitive keywords. In case of asmcmd you might use asm+ (also supplied) to use all features of the extensions.