rlwrap——sqlplus靈活使用上下鍵、退格鍵

在Linux下面使用sqlplus很不方便，上下鍵，退格鍵都不能用，嚴重降低生產效率。

而rlwrap可以解決此問題！

 下載rlwrap：http://download.csdn.net/detail/sharqueen/5433087

一:安裝readline（安裝相應的rpm包）

OS的安裝光碟片裡提供了readline包.

[root@oracle11g ~]# rpm -Uvh readline*

error: Failed dependencies:libtermcap-devel is needed by readline-devel-5.1-1.1.i386.rpm

[root@oracle11g ~]# rpm -Uvh libtermcap-devel-2.0.8-46.1.i386.rpm

[root@oracle11g ~]# rpm -Uvh readline*

package readline-5.1-1.1 is alreadyinstalled

[root@oracle11g ~]# rpm -Uvh readline-devel-5.1-1.1.i386.rpm

 

二:安裝rlwrap

[root@oracle11g ~]# tar -zxvf rlwrap-0.30.tar.gz

[root@oracle11g ~]# cd rlwrap-0.30

[root@oracle11g rlwrap-0.30]# ./configure

checking build system type...x86_64-unknown-linux-gnu

checking host system type...x86_64-unknown-linux-gnu

………

configure: creating ./config.status

config.status: creating Makefile

config.status: creating doc/Makefile

config.status: creating src/Makefile

config.status: creating doc/rlwrap.man

config.status: creatingdistribution/rlwrap.spec

config.status: creating config.h

config.status: executing depfiles commands

 

Now do:

   make (or gmake)  to build rlwrap

   make check       for instructionshow to test it

   make install     to install it

 

[root@oracle11g rlwrap-0.30]# make

[root@oracle11g rlwrap-0.30]# make install

 

三:方便使用rlwrap

[root@oracle11g rlwrap-0.30]# vi /home/oracle/.bash_profile

添加

alias sqlplus='rlwrap sqlplus'

alias rman='rlwrap rman'

 

之後再用命令sqlplus / as sysdba 串連資料庫時就會調用rlwrap這個工具，使得Linux下的SQL Plus可以像Windows下的那樣使用了。