sqlplus 上下键

1,上下键

rlwrap is a 'readline wrapper' that uses the GNU readline library to allow the editing of keyboard input for any other command. Input history is remembered across invocations, separately for each command; history completion and search work as in bash and completion word lists can be specified on the command line

tar zxvf rlwrap-0.42.tar.gz
cd rlwrap-0.42
./configure
make & make install
然后在oracle本地目录.bash_profile中追加
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'

如果出现 You need the GNU readline library(ftp://ftp.gnu.org/gnu/readline/ ) to build this program!，则执行

yum install readline*

2，del键取消显示^H
在oracle本地目录.bash_profile中追加
stty erase ^H
生效 source .bash_profile