Configure rlwrap

Configure rlwrap on Mac OS X

 * Download the installation file from http://www.macports.org/install.php, Choose Lion.


 * Install the downloaded package installation file.

export PATH=/opt/local/bin:/opt/local/sbin:$PATH
 * During the installation, the package will update the profile file to include the following:

. ~/.bash_profile
 * So you may need to source the updated profile before proceed with rlwrap installation. Otherwise, when running to install the rlwarp, it may say that *port* is not found.

$ sudo port install rlwrap
 * Install rlwrap

$ sudo port selfupdate
 * If it says that rlwrap cannot be found, try to get update first.

$ rlwrap sqlplus user@sid
 * Once successfully installed, you now can use rlwrap, for example,

alias sqlplus='rlwrap sqlplus'
 * Or you can create an alias for as a shortcut.


 * In addition, Tanel Poder has enhanced the rlwrap by having capability, in addition to recalling history, but also to search keywords in Oracle.

alias sqlplus='rlwrap -D2 -irc -b'\"@{}[],+=&^%#;|\'\ -f ~/Documents/Oracle_Scripts/tpt/setup/wordfile_11gR2.txt $INSTANT_CLIENT_PATH/sqlplus'
 * This is the sample. You can find out more from setup/README_rlwrap.txt file in the tpt_public.zip


 * To use, for example,

SQL> select * from dba_mview

[tab] to complete

SQL> select * from DBA_MVIEW

[tab] [tab] to show all possible values

SQL> select * from DBA_MVIEW DBA_MVIEWS                    DBA_MVIEW_DETAIL_SUBPARTITION DBA_MVIEW_AGGREGATES          DBA_MVIEW_JOINS DBA_MVIEW_ANALYSIS            DBA_MVIEW_KEYS DBA_MVIEW_COMMENTS            DBA_MVIEW_LOGS DBA_MVIEW_DETAIL_PARTITION    DBA_MVIEW_LOG_FILTER_COLS DBA_MVIEW_DETAIL_RELATIONS    DBA_MVIEW_REFRESH_TIMES

SQL> select * from DBA_MVIEW

References:
 * http://www.cjtravis.com/?p=744
 * http://tech.e2sn.com/oracle-scripts-and-tools

Related Posts:
 * Install_Oracle_Instant_Client_on_Mac_OS_X

Configure rlwrap on Linux

 * Download the latest from http://utopia.knoware.nl/~hlub/uck/rlwrap/

gunzip rlwrap*.gz tar -xvf rlwrap*.tar cd rlwrap* ./configure make make check make install
 * Install as follows:


 * If during the configure, you encounter "You need the GNU readline library(ftp://ftp.gnu.org/gnu/readline) to build this program!", in addition to the "readline", you will also need the "readline-devel".
 * 1) yum install readline-devel

References:
 * http://www.oracle-base.com/articles/linux/rlwrap.php
 * http://d-h-n.de/blog/rlwrap-you-need-the-gnu-readline-libraryftpftp-gnu-orggnureadline-to-build-this-program