让sqlplus支持上下键

rlwrap 支持上下键和回退键来浏览和编辑命令

rlwrap compiles and runs on most Unix(-like) systems

下载rlwrap

http://utopia.knoware.nl/~hlub/uck/rlwrap/

readme

http://utopia.knoware.nl/~hlub/uck/rlwrap/README.txt

how to install:

#tar -xzvf *gz

# ./configure; make install

how to use it:

vi ~/.bash_profile 

alias sqlplus='rlwrap sqlplus'