By default, start Sqlplus, if the input error code want to adjust, there will be strange characters, such as:
Sql> conn^[[d^[[d^[[d
Rlwrap can be used to support the callback function of Oracle's Sqlplus History command to improve productivity.
1. Download
Download the rlwrap-0.42.tar.gz from http://utopia.knoware.nl/~hlub/uck/rlwrap/and upload it to Linux.
2. Unzip the installation
[Email protected] home]# TAR-ZXVF rlwrap-0.42.tar.gz
[[email protected] home]# ls
[Email protected] home]# CD rlwrap-0.42
[Email protected] rlwrap-0.42]#./configure
[[email protected] rlwrap-0.42]# make &make Install
3. Edit the. Bash_profile increase under Oracle user
[Email protected] ~]$ vim ~/.bash_profile
Alias sqlplus= ' Rlwrap sqlplus ';
Alias rman= ' Rlwrap Rman ';
4. Execute the source ~/.bash_profile to make the configuration effective
5. Once the sqlplus is executed, the callback function of the history command can be used, and the arrow keys can be used normally.
Install Rlwrap under Linux