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

This entry was posted on Saturday, July 4th, 2009 at 6:44 pm and is filed under Administration, Video Tutorials. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

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

  1. Emre Baransel Says:
    July 6th, 2009 at 10:36 pm

    Thanks Kamran,
    For this useful video!

  2. Kamran Agayev A. Says:
    July 7th, 2009 at 8:58 am

    Hi Emre. Welcome to my blog :)

  3. aditt Says:
    July 7th, 2009 at 5:52 am

    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:
    July 7th, 2009 at 9:00 am

    Good Luck Aditt !

  5. Ahmet Says:
    July 7th, 2009 at 5:57 pm

    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:
    July 7th, 2009 at 6:02 pm

    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:
    August 31st, 2009 at 12:18 pm

    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:
    April 26th, 2010 at 6:54 pm

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

  9. Zafer Says:
    August 27th, 2010 at 4:18 am

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

    http://ivan.kartik.sk/

    See the Downloads section on the blog

    Hope this proves useful
    R/ Zafer

  10. kasante Says:
    November 23rd, 2010 at 9:48 pm

    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:
    November 23rd, 2010 at 10:39 pm

    hello kamran, thanks i am done with it. thanks

  12. KAMAL Says:
    December 21st, 2010 at 10:19 am

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

  13. Kamran Agayev A. Says:
    December 21st, 2010 at 10:22 am

    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:
    May 15th, 2011 at 8:10 pm

    Great tutorial. Thanks

  15. Xhavit Cecelia Says:
    May 31st, 2011 at 9:49 pm

    Great tutorial . thankss

  16. Sham G Says:
    September 7th, 2014 at 1:58 pm

    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.

    Thanks.

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>

«
»