rlwrapis a Linux command which provides line editing, persistent history and word completion for command line tools such as sqlplus and rman.
rlwrapbefore your command as follows.
Now you can use the up and down arrow keys to retrieve your history, even across invocations of the command. You can also edit the line using the left and right keys, deleting and inserting text as required.rlwrap sqlplus scott/tiger
The -c option enables file completion which can be useful when running scripts. If you type @ and the start of a file name and press tab,
rlwrapwill complete the name of the file for you.
You can also specify a file containing your own list of words to be auto-completed.
This file could contain a list of tables and views in your schema, for example.rlwrap -c -f mywordlist.txt sqlplus scott/tiger