Wednesday, November 9, 2011

Oracle - wrapping sqlplus with rlwrap

A tiny but powerful tip is to wrap around the sqlplus utility with rlwrap so you can have autocompletion and history recall functions, editing line mode and reverse search.

One prerrequisite is to have the readline development libraries which in my particular case (centos 5) are available under the name readline-devel, so

yum install readline-devel

once you've downloaded and installed rlwrap

http://utopia.knoware.nl/~hlub/rlwrap/

you call sqlplus with something like:

awesome=# rlwrap sqlplus

and have a lot of fun!

 

 

 

No comments:

Post a Comment