seland when pressing the tab key rlwrap completes it to
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:
#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/completionsand put the scripts
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.