Feature TourFeature Tour

SQL Commander

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. The Explain Plan feature in supports DB2 LUW, H2, JavaDB/Derby, Mimer SQL, MySQL, Netezza, NuoDB, Oracle, PostgreSQL 9+, Redshift, SQLite, SQL Server, and Vertica.


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 4 select statements and their respective result as grid tabs in the lower part.
SQL Editor with Auto Completion and result sets in Grid format

If you select a statement in the editor and execute, only that statement is executed.
The result set tab show 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 (${name}$) 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.
Parameterized SQL using variables

DbVisualizer supports the most common parameter marker formats such as ?, :name, :{name}, :'name' and &name.
DbVisualizer will prompt for values at execution of SQL(s) containing any of these.
Parameterized SQL using markers

The result set area belonging to an SQL Commander can be displayed in its own standalone window
allowing for full height editing of SQL scripts and viewing of results.
Show Result Sets in separate Window

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, Mimer SQL, and Sybase ASE (jConnect).
Error highlighting
Feature DbVisualizer
» 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)
» Predefined and user defined editor templates
» 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
» Error highlighting in editor