Oracle下的sqlplus中不能使用方向、退格键,从网上查下有小工具可以实现,就弄个玩玩了,毕竟方便。

  linux下使用rlwrap回调sqlplus中执行过的命令

  从官方下最新

  rlwrap-0.37.tar.gz  http://utopia.knoware.nl/~hlub/uck/rlwrap/

  安装

  [root@sunsyk src]# tar xvfz rlwrap-0.37.tar.gz

  [root@sunsyk src]# cd rlwrap-0.37

  [root@sunsyk rlwrap-0.37]# ./configure --prefix=/usr/local/rlwrap

  [root@sunsyk rlwrap-0.37]# make && make install

  使用

  [root@sunsyk rlwrap-0.37]#vim /home/oracle/.bashrc

  添加

  alias sqlplus='rlwrap sqlplus'

  alias rman='rlwrap rman'

  PATH=/oracle/10g/bin/:/usr/local/rlwrap/bin/:$PATH

  export PATH

  [root@sunsyk rlwrap-0.37]# su - oracle

  [oracle@sunsyk ~]$ /usr/local/rlwrap/bin/rlwrap sqlplus / as sysdba

  SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 27 21:29:05 2009

  Copyright (c) 1982, 2005, Oracle.  All rights reserved.

  Connected to:

  Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

  With the Partitioning, OLAP and Data Mining options

  SQL> show user

  USER is "SYS"

  SQL>