Kamran Agayev’s Oracle Blog

Kamran Agayev’s Oracle Blog

Using rlwrap to get command line history in SQL*Plus – Video Tutorial

Posted by Kamran Agayev A. on July 4, 2009

By viewing .bashrc file, it wasn’t recorded the “alias line” which I’ve added
The line is as below:

alias rlsqlplus=’rlwrap sqlplus’

Additionaly, you can download rlwrap software from below link:
P.S. Thanks for Tim for his article

15 Responses to “Using rlwrap to get command line history in SQL*Plus – Video Tutorial”

  1. Thanks Kamran,
    For this useful video!

  2. aditt said

    wow, this is great, we can have history in SQL*Plus instead of ^[[A 😛

    thanks, downloading, and then i’ll try it 😀

  3. Hi Emre. Welcome to my blog 🙂

  4. Good Luck Aditt !

  5. Ahmet said

    Thank you for this useful information!

    Is it necessary to shutdown all Oracle processes (database,listener, etc.) on the server before apply it? Or should I plan an outage for this change?

  6. You’re welcome Ahmet
    It’s not necessary to shutdown Oracle, listener and etc. Just install this software, make changes to bashrc file to add an alias in order to simplify its usage. That’s all 🙂

  7. Dinesh said

    Hi Kamran,

    Nice Utility. I was wondering same thing for SOLARIS also. :).
    Thanks in advance.

    best regards,

    Dinesh Parihar

  8. […] https://kamranagayev.wordpress.com/2009/07/04/using-rlwrap-to-get-command-lines-history-in-sqlplus-vi… […]

  9. Zafer said

    For rlwrap downloads for different platforms (including Solaris x86 and Sparc) check out Ivan’s blog:


    See the Downloads section on the blog

    Hope this proves useful
    R/ Zafer

  10. kasante said

    dear mr. kamran, please after downloading it appears to like this rlwrap-0.30.tar.gz. please help me install it.thanks

  11. kasante said

    hello kamran, thanks i am done with it. thanks

  12. KAMAL said

    Hi Sir,
    Is your book (Expert secrets for using RMAN and Data Pump) available in India Delhi..

  13. Dear Kamal

    It’s not published yet. When it will be published, it wil be available in India as well

  14. Great tutorial. Thanks

  15. Xhavit Cecelia said

    Great tutorial . thankss

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

%d bloggers like this: