What is gqlplus?
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. sqlplus does give you ability to use external
editor to edit a statement, but only the last statement you
typed. gqlplus 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 sqlplus. 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.
How does gqlplus differ from other sqlplus front-end programs?
There are a number of other sqlplus front-end programs which include
this functionality. They, however, require some user training, and may
not be as easy to install (requiring particular version of Perl,
and/or particular set of Perl modules, and/or configuration files). In
contrast, the design goal of gqlplus was to remain as close as
possible to sqlplus, with the addition of command-line editing and
table and column name completion. The command-line editing will be
familiar to UNIX users since it works as in command-line
shells. Additionally, there are no installation issues since the
program is a single binary executable.
Click here and you
will be taken to SourceForge 'Summary' page for the gqlplus
project. Click 'Download gqlplus'. That takes you to the project
'Files' page. Select the version you would like to download (typically
the latest one, which will already be highlighted), click on it, and
the download file dialog should pop-up within a few seconds. If it
does not, click on 'Download' for the chosen mirror location and the
download will start. The downloaded file is a .gz tar file which
contains basic instructions, the GPL license, source file gqlplus.c
and precompiled executable for Linux/Intel platform.
The current version of gqlplus is 1.12. The corresponding MD5
checksum is:
Linux/Intel: da1f5ab0d270c85346cf6dae99f6e0f7
gqlplus accomplishes its functionality through the use of the GNU
Readline library.
Who wrote gqlplus?
Ljubomir
J. Buturovic of San Francisco State University, San Francisco, California. Please
send all feedback to ljubomir@sfsu.edu.
Acknowledgement
This page is hosted at SourceForge. Many thanks to people at VA
Software for providing this valuable public service to Open Source
community.
