 |
|
SQL*Plus Command History Key Display
Oracle Tips by Kamran Agayev
Agamehdi
March 15, 2010
|
Question: I know that I can repeat my previous SQL*Plus
commands in Windows but I want to cruise though my SQL*Plus command history
in UNIX and Linux.
How do I get the command line history in non-windows Oracle versions of
SQL*Plus?
Answer: Yes, the Windows version of SQL*Plus also has a
command history that you can cycle through using the Up/Down arrows (or F7),
and this saves a lot of re-typing of commands.
Luckily, In UNIX and Linux, you can quickly install the
rlwrap utility to see
the SQL*Plus command line history and quickly recall previous SQL*Plus
commands.
See here for using
rlwrap to display SQL*Plus command history.
In UNIX and Linux, you can
use the up-arrow key to display the command history, but the up-arrow key
does not work when you are inside SQL*Plus.
To enable the up arrow key
for Oracle you need to install a special package and the up arrow key will
then work inside Oracle.
This video shows how to use
the rlwrap package to make the up-arrow key display a command history from
the SQL*Plus prompt.
Kamran Agayev
Agamehdi is an Oracle Certified Professional DBA (9i, 10g) with over 5
years experience with UNIX Systems and with Oracle Databases and author of
Oracle Backup & Recovery by Rampant Tech Press.
