SQL*Plus command line history completion

 

The rlwrap (readline wrapper) utility provides a command history and editing of keyboard input

for any other command. This is a really handy addition to SQL*Plus and RMAN .

Download the latest rlwrap software from the following URL.
http://utopia.knoware.nl/~hlub/uck/rlwrap/

Unzip and install the software using the following commands.

gunzip rlwrap*.gztar -xvf rlwrap*.tarcd rlwrap*./configuremakemake checkmake install

Run the following commands, or better still append then to the “.bash_profile” of the

oracle software owner.

alias sqlplus=’rlwrap ${ORACLE_HOME}/bin/sqlplus’
alias rman='rlwrap ${ORACLE_HOME}/bin/rman'
alias expdp='rlwrap ${ORACLE_HOME}/bin/expdp'

You can now start SQL*Plus or RMAN using “sqlplus” and “rman” respectively, and you will have

a basic command history and the current line will be editable using the arrow and delete keys.

Leave a Reply