It is inconvenient to use SQL * Plus on Linux, that is, there is no historical callback function. For SQL * Plus on Windows, you can use the "Up and down" arrow to call commands that have been used before. It is quite convenient to modify, edit, and repeat previous commands. How can this problem be solved?
The answer is to install a tool: uniread
Uniread installation requirements
1. Perl must be installed on Linux
2. Install the Readline, term, and Io tools before installing uniread.
You can download it from here:
Uniread-1.01.tar.gz: http://download.csdn.net/source/384464
Readline-5.2.tar.gz: http://download.csdn.net/source/384466
Term-ReadLine-Gnu-1.17a.tar.gz: http://download.csdn.net/source/384470
IO-Tty-1.07.tar.gz: http://download.csdn.net/source/384468
Installation Process:
1. Check whether Perl has been installed
[Root @ pcmxexweb TMP] # rpm-Qa Perl
Perl-5.8.8-10
# It indicates that you have installed
2.download io-tty-1.07.tar.gz readline-5.2.tar.gz Term-ReadLine-Gnu-1.17a.tar.gz uniread-1.01.tar.gz these four files, I put under/tmp.
[Root @ pcmxexweb TMP] # ll IO-Tty-1.07.tar.gz readline-5.2.tar.gz Term-ReadLine-Gnu-1.17a.tar.gz uniread-1.01.tar.gz
-RW-r -- 1 Root 22004 03-14 IO-Tty-1.07.tar.gz
-RW-r -- 1 Root 2037705 03-14 readline-5.2.tar.gz
-RW-r -- 1 Root 66489 03-14 Term-ReadLine-Gnu-1.17a.tar.gz
-RW-r -- 1 Root 16118 03-14 uniread-1.01.tar.gz
3.install readline-5.2.tar.gz
# Tar-zxvf readline-5.2.tar.gz
# Cd readline-5.2
#./Configure
# Make
# Make install
4. Install io-tty-1.07.tar.gz and Term-ReadLine-Gnu-1.17a.tar.gz
# Tar-zxvf IO-Tty-1.07.tar.gz (or tar-zxvf Term-ReadLine-Gnu-1.17a.tar.gz)
# D IO-Tty-1.07 (or CD Term-ReadLine-Gnu-1.17)
# Perl makefile. pl
# Make
# Make install
5.install readline-5.2.tar.gz
# Tar-xzvf uniread-1.01.tar.gz
# Cd uniread-1.01
# Perl makefile. pl
# Make
# Make install
6. Usage:
# Su-Oracle
$ Uniread sqlplus/nolog
7. Clear history records:
$ Echo ''>. uniread/sqlplus