rlwrap的安裝使用 [SQLPlus上下鍵]
?
?
os:Oracle-Enterprise-R5-U2-Server-i386
Oracle:linux_x86_11gR1_database
??? 在Windows操作系統(tǒng)上,當(dāng)在DOS命令窗口中運行SQL*Plus的時候,可以使用向上,向下鍵來跳回之前已經(jīng)執(zhí)行過的SQL語句.你可以根據(jù)需要修改他們,然后按Enter鍵重新提交執(zhí)行.然而,當(dāng)在Linux Shell中運行SQL*Plus的時候,并不提供瀏覽歷史命令行的功能.為了在Linux中達到同樣的目的,你可以安裝rlwrap,這個程式本身是個Shell,可以運行任何你提供給它的命令包括參數(shù),并添加命令歷史瀏覽功能.The rlwrap program is under the GPL license.
?
?
一:安裝readline
OS的安裝光盤里提供了readline包.
[root@oracle11g ~]# rpm -Uvh readline*
error: Failed dependencies: libtermcap-devel is needed by readline-devel-5.1-1.1.i386.rpm
[root@oracle11g ~]# rpm -Uvh libtermcap-devel-2.0.8-46.1.i386.rpm
[root@oracle11g ~]# rpm -Uvh readline*
package readline-5.1-1.1 is already installed
[root@oracle11g ~]# rpm -Uvh readline-devel-5.1-1.1.i386.rpm
?
?
二:安裝rlwrap
Download：
http://utopia.knoware.nl/~hlub/uck/rlwrap/
[root@oracle11g ~]# tar -zxvf rlwrap-0.30.tar.gz
[root@oracle11g ~]# cd rlwrap-0.30
[root@oracle11g rlwrap-0.30]# ./configure
[root@oracle11g rlwrap-0.30]# make
[root@oracle11g rlwrap-0.30]# make install
[root@oracle11g rlwrap-0.30]# rlwrap
Usage: rlwrap [options] command ...
?
Options:
? -a[password:]????????????? --always-readline[=password:]
? -A???????????????????????? --ansi-colour-aware
? -b <chars>???????????????? --break-chars=<chars>
? -c???????????????????????? --complete-filenames
? -C <name|N>??????????????? --command-name=<name|N>
? -D <0|1|2>???????????????? --history-no-dupes=<0|1|2>
? -f <completion list>?????? --file=<completion list>
? -F <format string>???????? --history-format=<format string>
? -h???????????????????????? --help
? -H <file>????????????????? --history-filename=<file>
? -i???????????????????????? --case-insensitive
? -l <file>????????????????? --logfile=<file>
? -n???????????????????????? --no-warnings
? -p[ANSI colour spec]?????? --prompt-colour[=ANSI colour spec]
? -P <input>???????????????? --pre-given=<input>
? -q <chars>???????????????? --quote-characters=<chars>
? -m[newline substitute]???? --multi-line[=newline substitute]
? -r???????????????????????? --remember
? -v???????????????????????? --version
? -s <N>???????????????????? --histsize=<N> (negative: readonly)
? -t <name>????????????????? --set-term-name=<name>
?
?
三:使用rlwrap
[oracle@oracle11g ~]$ sqlplus / as sysdba
?
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Jul 29 21:28:30 2008
?
Copyright (c) 1982, 2007, Oracle.? All rights reserved.
?
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
?
SQL> select * from v$sga;
?
NAME????????????????????? VALUE
-------------------- ----------
Fixed Size????????????? 1299116
Variable Size???????? 155192660
Database Buffers?????? 79691776
Redo Buffers??????????? 2347008
?
使用向上鍵調(diào)回最后執(zhí)行的命令,按Enter鍵重新執(zhí)行或修改后按Enter鍵執(zhí)行.
SQL> select * from v$sga;
?
NAME????????????????????? VALUE
-------------------- ----------
Fixed Size????????????? 1299116
Variable Size???????? 155192660
Database Buffers?????? 79691776
Redo Buffers??????????? 2347008
?
SQL>
?
?
Note:
解決在sqlplus下輸錯命令后正常刪除的方法
[oracle@oracle11g ~]$ vi /home/oracle/.bash_profile
添加
stty erase ^h
?
?
?
?