Monday, August 8, 2011

Want to know how to get the SQLPLUS command history

If you are running sqlplus or RMAN on Windows than you can use upper arrow to get history.What about linux?

First option:

1) Install readline wrapper:

yum install rlwrap

2) Change .bashrc and make alias :

alias sqlplus=’rlwrap sqlplus’ alias rman=’rlwrap rman’

The other option is to install qqlplus which you can find on the link

http://gqlplus.sourceforge.net/

I tried it on my Oracle 11 running Linux 64bit and did not work.I used already made executable under Linux folder ( included into compressed source file ) but I am sure this can be fixed by comipiling source code.

No comments:

Post a Comment