Rlwrap (use the up and down keys under Sqlplus)

One: Installation ReadLine

The ReadLine package is available in the OS installation CD.

# RHEL 4 [[email protected] ~]# RPM-UVH readline*error:failed dependencies:libtermcap-devel are needed by readline-devel -5.1-1.1.i386.rpm[[email protected] ~]# RPM-UVH libtermcap-devel-2.0.8-46.1.i386.rpm[[email protected] ~]# RPM-UVH Readline*package readline-5.1-1.1 is already installed[[email protected] ~]# RPM-UVH readline-devel-5.1-1.1.i386.rpm# RHEL 5 [[email protected] ~]# RPM-IVH readline* libtermcap-devel*

Two: Install Rlwrap

[Email protected] ~]# TAR-ZXVF rlwrap-0.30.tar.gz[[email protected] ~]# CD Rlwrap-0.30[[email protected] rlwrap-0.30]#. /configure[[email protected] rlwrap-0.30]# Make[[email protected] rlwrap-0.30]# make install

Three: Easy to use Rlwrap

[[email protected] rlwrap-0.30]# vi/home/oracle/.bash_profile add alias sqlplus= ' Rlwrap sqlplus ' Alias rman= ' Rlwrap Rman '

SQL Plus under Linux can finally be used like Windows.

Rlwrap (use the up and down keys under Sqlplus)