History in sqlplus

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

PostgreSQL for Solaris

Oh, this weekend is happening the PostgreSQL Conference 2008 in Brazil. It’s a great opportunity to post in my blog something related with it. As Sun Microsystems will be a sponsor of the Conference, I will talk a little about PostgreSQL for Solaris.

First, a bad notice that Josh Berkus is no longer in Sun. =(

Second…

Well, I’m not a OpenSolaris expert, but I like it. Always I have to setup or make PostgreSQL tricks on Sun Operating Systems (SunOS/Solaris or OpenSolaris) I consult some useful links:

• Main wiki
• Best Practices Howto (by Jignesh K. Shah – US PGCon 2008)
• Sun Guide to PostgreSQL

PostgreSQL for Solaris

Go PostgreSQL, Go !!!

PGCon Brasil 2008

PGCon Brasil 2008