WARNING: This web is not used anymore. Please use PDBService.RlWrap instead!
 

sqlplus for linux with command line history and editing:


rlwrap is a 'readline wrapper', a small utility that uses the GNU readline library to allow the editing of keyboard input for any command (arrow keys, history, search with CTRL-R, command name completion with dictionary)
credits to http://utopia.knoware.nl/~hlub/uck/rlwrap/
a compiled version of rlwrap 0.23 + readline 4.3 for RHEL 3 is added to this page:
  • rlwrap-023: rlwrap 0-23 using readline 4.3, compiled and tested on RHEL ES3



rlwrap install instructions:

  1. Download rlwrap from this page (see below) and/or compile it from source
  2. Execute the following:
    RLWRAPDIR=/usr/local/bin
    sudo cp rlwrap-023 $RLWRAPDIR/rlwrap-023
    echo "select" > rlwrap_dict
    echo "from" >> rlwrap_dict
    sudo cp rlwrap_dict $RLWRAPDIR/
    Note: You can add more entries in the dictionary, sqlplus will use them as shortcuts (use the tab key to access them)
  3. Edit .bashrc and add the following aliases
    RLWRAPDIR=/usr/local/bin
    alias sqlp="rlwrap-023 -f $RLWRAPDIR/rlwrap_dict sqlplus"
    alias sqlsys="rlwrap-023 -f $RLWRAPDIR/rlwrap_dict sqlplus / as sysdba"
  4. Reload the bash shell. The aliases sqlp and sqlsys can be used instead of sqlplus to use the command line history (arrow keys) with sqlplus.

rlwrap is referenced also in the installation procedure Installation_verbose

Topic attachments
I Attachment History Action Size Date Who Comment
Unknown file formatext rlwrap-023 r1 manage 38.9 K 2006-05-31 - 19:02 LucaCanali rlwrap 0-23 using readline 4.3, compiled and tested on RHEL ES3
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2006-07-26 - LucaCanali
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    PSSGroup All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2020 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback