Command history for sqlplus - rlwrap !!

There’s a utility called rlwrap that you can install and once that is done, you can use UP arrow and sqlplus remembers your previous commands (as in MS-DOS).

This procedure is for Sun Solaris Sparc 64 bit OS.

Step 1 :

1. Download ncurses-5.4-sol10-sparc-local.gz from http://solaris-freeware.saix.net/programlistsparc10.html

2. Download readline and rlwrap packages from http://ivan.kartik.sk/index.php?show_article=26

Step 2 :

To install rlwrap on Solaris execute following commands:

gunzip ncurses-5.4-sol10-sparc-local.gz
gunzip readline-5.2-solaris9-sparc.gz
gunzip rlwrap-0.28-solaris9-sparc.gz

pkgadd -d readline-5.2-solaris9-sparc
pkgadd -d rlwrap-0.28-solaris9-sparc
pkgadd -d ncurses-5.4-sol10-sparc-local

Step 3 :

As readline library is located in /usr/local/lib don't forget to add that line to LD_LIBRARY_PATH.

Also put following line to your .profile:

alias sqplus='/usr/local/bin/rlwrap sqlplus'

-