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

3 Responses to “History in sqlplus”

  1. Rocco Says:

    Roccooooo!

  2. Roko Says:

    Rocco parabéns!

  3. Roko Says:

    isso aqui ta parado hein!!


Leave a Reply