Rlwrap, the first.

March 26, 2010 at 2:33 pm | Posted in Oracle Tools | 2 Comments
Now with rlwrap you get a few more benefits than just a command history. I didn’t find out about this until attending Tanel Poder’s training day at the Hotsos Symposium. That’s what I get for not reading the man page, or else I would have known about these other benefits much sooner.
Who reads man pages anyway. Reading man pages is like asking for directions when your taking a hot girl out on your first date in your cool convertible.
So, the additional benefits of rlwrap are the searchable command history and the key bindings.  Rlwrap, by default, uses Emacs key bindings. So CTRL-r searches the command history backwards, ctrl-a/e goes to the beginning/end of a line, etc.
I’m more of a vi guy than an Emacs man, so I looked around for getting the vi key bindings to work in sqlplus.
To get this to work, simply edit your /etc/inputrc or ~/.inputrc, and add the lines:
set editing-mode vi
set keymap vi
Restart your shell and you have vi inside sqlplus! What could be better?
For more info see the Vim Wiki and/or this.
For quick installation instructions of rlwrap see: Rlwrap, the third.
Advertisements

2 Comments »

RSS feed for comments on this post. TrackBack URI

  1. awesome
    I’m totally a vi guy and couldn’t figure out how to get vi rolling in rlwrap until I turned your page up.
    Thanks
    Kyle

  2. I hardly drop remarks, but after looking at through
    a few of the responses on this page Rlwrap, the
    first. | Christoph’s 2 Oracle Cents. I do have 2 questions for you if you tend not to mind. Could it be just me or does it look like some of these comments look like they are left by brain dead visitors? 😛 And, if you are writing on other online social sites, I would like to keep up with you. Would you make a list of the complete urls of your social community pages like your linkedin profile, Facebook page or twitter feed?


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Entries and comments feeds.

%d bloggers like this: