GsqlR2 is a user-friendly software interface designed for Oracle application development and testing, utilizing GTK2 technology. It streamlines the process and enables more efficient software creation and quality assurance.
I have recently come across GsqlR2, a GTK2 interface built for Oracle application development and testing. This software is packed with a variety of useful features such as a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, as well as a tracing facility, and SQL*Plus-style command scripting.
Furthermore, for SQL statement analysis and tuning, there is a tree-style SQL statement "explain plan" facility that allows for efficient analysis and streamlined optimizing. Additionally, the software also enables users to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository (in Oracle version 10g), and full AWR reports.
To run GsqlR2, users are required to have GTK+ version 2.4.x and Oracle 9 or 10 client libraries (although Oracle Instant Client will also work). Moreover, for those with Glib 2.6 or greater, the software will save a .ini file across restarts.
In the latest release of GsqlR2, there have been exciting explain plan enhancements added. In specific, a ">>" symbol next to object names now represent filter predicate. Overall, GsqlR2 is an intuitive software packed with an incredible amount of useful features that will serve any developer or tester well.
Furthermore, for SQL statement analysis and tuning, there is a tree-style SQL statement "explain plan" facility that allows for efficient analysis and streamlined optimizing. Additionally, the software also enables users to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository (in Oracle version 10g), and full AWR reports.
To run GsqlR2, users are required to have GTK+ version 2.4.x and Oracle 9 or 10 client libraries (although Oracle Instant Client will also work). Moreover, for those with Glib 2.6 or greater, the software will save a .ini file across restarts.
In the latest release of GsqlR2, there have been exciting explain plan enhancements added. In specific, a ">>" symbol next to object names now represent filter predicate. Overall, GsqlR2 is an intuitive software packed with an incredible amount of useful features that will serve any developer or tester well.
What's New
Version 1.46: N/A