Feature TourFeature Tour

SQL Editor

Previous Next

The SQL Commander supports multiple editors and result sets, bookmark feature, formatting, script execution and extensive customization. Result sets can be edited, viewed in text or chart format. Explain plan can be executed for Oracle, DB2 for LUW, SQL Server, Mimer SQL, and PostgreSQL 9+.

 

                  
The SQL Editor supports auto completion which is an aid used to complete
sentences with either table or column names. Specify the beginning of a table
name and then press Ctrl+SPACE to show a list of matching names. The screenshot
show 3 select statements and their respective result as grid tabs in the lower part.
SQL Editor with Auto Completion and result sets in Grid format

                  
A result set displayed with the Text output format.
Execution of selected SQL with result set in fixed width Text format

                  
Any result set may be presented as a chart. There are several options
to control the appearance and these are preserved for new result sets
when running more select statements.
Result set in Chart format

                  
The data in a result set may be edited via the inline or form editors, as long as certain conditions are fulfilled.
Edit result set either inline or in the form editor
 

                  
Enter variables in the script and DbVisualizer will prompt for real values
at execute. The variable window remembers previously used values and is useful
if running the same SQL only with minor differences between the runs.
Variables in the SQL

                  
Finding errors in SQL scripts may be a tedious process. The error highlighting in
the SQL Commander show errors with a wavy underline and when hovered the error text is
displayed. Error highlighting is supported for Oracle, MySQL, PostgreSQL,
Informix, JavaDB/Derby and Mimer SQL.
Error highlighting
Feature DbVisualizer
Pro
DbVisualizer
Free
» Execute Script with a single SQL statement
» Execute Script with multiple SQL statements
» Execute single SQL statement at cursor position
» Execute selected SQL statement(s)
» Execute Buffer (as a single SQL statement)
» Execute Explain Plan
» Syntax colored SQL editor
» Auto Completion (aka code completion, intellisense)
» Support for multiple SQL editors
» Support for procedures producing multiple result sets
» SQL formatter with extensive customization options
» Execution control (stop on error/warning)
» View result sets as grid, text or chart Grid, Text, Chart Grid
» Editable result sets with the inline or form editors
» Support for BLOB, CLOB and binary data
» View BMP, TIFF, PNG, GIF and JPEG images
» View PDF documents
» View XML data in tree or text format
» Export result sets with Create Table option CSV, HTML, XLS, XLSX, XML, SQL CSV, HTML
» Export large result sets directly to file (@export)
» Parameterized SQL queries
» Supports objects dragged from the Database Browser
» Drop files from Desktop or external tools
» SQL execution logging with filtering options
» Pre-defined editing key maps
» Merge Result Sets in Text Format
» Error highlighting in editor