Gqlplus serves as a substitute for Oracle SQL client, sqlplus, on UNIX and UNIX-like systems. It can be easily installed and utilized as a replacement.
Most notably, gqlplus incorporates command-line editing and history, and table-name and column-name completion. These features may sound simple, but anyone who has used sqlplus knows that they can make a big difference in catching and correcting errors in your SQL statements.
Although sqlplus does provide the ability to use an external editor as a workaround for editing statements, gqlplus takes care of this much more elegantly by providing the standard command-line editing and history found in tcsh or bash shells.
Despite the added features, gqlplus remains highly compatible with sqlplus, so users don't need any special training. In fact, configuring and installing gqlplus are both simple tasks. Since the program is a single binary compiled executable, users merely need to download it and place it anywhere in their PATH.
For those who have explored other front-end programs that provide similar features, gqlplus offers a unique advantage. Whereas other programs may require special training or specific versions of Perl modules or configuration files, gqlplus retains maximum compatibility with sqlplus. The program remains as true as possible to sqlplus, with the added benefits of command-line editing and table and column name completion.
In the latest release of gqlplus, developers have addressed some bugs and added new functionality, including an ACCEPT command and progress reports with elapsed time information. Additionally, users can now use SIGTERM to kill sqlplus, and the program includes ORACLE_PATH and DYLD_LIBRARY_PATH environment variables.
Overall, gqlplus is a simple and effective upgrade for sqlplus users who want improved command-line editing and completion features without any extra hassle.
Version 1.12: N/A