 |
|
GQLPlus for Oracle
Oracle Tips by Burleson Consulting |
By Steve Karam
11/17/06I just found a link to a command line wrapper for
SQL*Plus called
GQLPlus. Supposedly this wrapper allows historical editing, table/column
name completion, and more.
Even better, it’s just a precompiled drop-in with SQL Plus. Download and run;
nothing else is required. From the website:
“gqlplus is a drop-in replacement for sqlplus, an Oracle SQL client, for
UNIX and UNIX-like platforms.
The difference between gqlplus and sqlplus is command-line editing and
history, plus table-name and column-name completion."
As you know if you have used sqlplus, it is notoriously difficult to correct
typing errors and other mistakes in your SQL statements. Oracle SQL*Plus does
give you ability to use external editor to edit a statement, but only the last
statement you typed.
The gqlplus tool solves this problem by providing the familiar command-line
editing and history as in tcsh or bash shells, and table/column-name completion,
while otherwise retaining compatibility with SQL*Plus.
Thus, no user training is needed - simply use gqlplus instead of sqlplus. In
addition, configuration/installation is trivial: gqlplus is a single binary
compiled executable (written in C), so all you need to do is download it and put
it anywhere in your PATH. After that, you’ll be ready to use it.”
