History in sqlplus
October 18, 2008
I think the sqlplus command is the better app to Oracle DBA’s daily work. Since I do not working with complex pl/sql scripts, I prefer sqlplus too. However, sqlplus has not a history feature as psql (PostgreSQL) and mysql (MySQL) – when these tools are compiled with readline library.
It exits a trick to enable history in sqlplus. The “workaround” is known as rlwrap. So, how do I do it ?
<———–
rlwrap sqlplus
or
alias sqlplus='rlwrap sqlplus'
———–>
Try it also with rman command.
You will save your time and your patience.
rlwrap: http://utopia.knoware.nl/~hlub/uck/rlwrap/
sqlplus documentation: http://download-west.oracle.com/docs/cd/B12037_01/server.101/b12170/toc.htm







