Kamran Agayev's Oracle Blog

Oracle Certified Master

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

Posted by Kamran Agayev A. on July 4th, 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

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

  1. Emre Baransel Says:

    Thanks Kamran,
    For this useful video!

  2. Kamran Agayev A. Says:

    Hi Emre. Welcome to my blog :)

  3. aditt Says:

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

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

  4. Kamran Agayev A. Says:

    Good Luck Aditt !

  5. Ahmet Says:

    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. Kamran Agayev A. Says:

    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 Says:

    Hi Kamran,

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

    best regards,

    Dinesh Parihar

  8. rlwrap linux for oracle sqlplus « DBA Says:

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

  9. Zafer Says:

    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 Says:

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

  11. kasante Says:

    hello kamran, thanks i am done with it. thanks

  12. KAMAL Says:

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

  13. Kamran Agayev A. Says:

    Dear Kamal

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

  14. Dilli R. Maharjan Says:

    Great tutorial. Thanks

  15. Xhavit Cecelia Says:

    Great tutorial . thankss

  16. Sham G Says:

    Hi Kamran ;

    It’s good ! Thanks for superb video.

    I tried to install rlwrap-0.41 but could NOT get succcess.

    But it’s fine with rlwrap-0.30.


Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>