SQL Editor |
|
|
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 and SQL Server
SQL Editor with Auto Completion and result sets in Grid format |
Execution of selected SQL with result set in fixed width Text format |
Result set in Chart format |
Edit result set either inline or in the form editor |
| Feature | DbVisualizer Personal |
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 | ||
| » SQL editors displayed as tabs or windows | ||
| » Result sets displayed as tabs or windows | ||
| » 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, XML, SQL | CSV, HTML |
| » Export large result sets directly to file (@export) | ||
| » Parameterized SQL queries | ||
| » Handle objects dragged from the Database Browser | ||
| » SQL execution logging with filtering options | ||
| » Pre-defined key maps |
