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

This entry was posted on July 4, 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.

Emre Baransel said

July 6, 2009 at 10:36 pm
Thanks Kamran,
For this useful video!
aditt said

July 7, 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
Kamran Agayev A. said

July 7, 2009 at 8:58 am
Hi Emre. Welcome to my blog
Kamran Agayev A. said

July 7, 2009 at 9:00 am
Good Luck Aditt !
Ahmet said

July 7, 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?
Kamran Agayev A. said

July 7, 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
Dinesh said

August 31, 2009 at 12:18 pm
Hi Kamran,

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

best regards,

Dinesh Parihar