SQL Editor

An powerful SQL Editor with text auto-completion, scripts and queries execution, Groovy scripting support, graphical explain execution plan.

SQL Editor

Edit Queries

Using the SQL Editor you can edit and execute queries.

Execute Scripts

You can execute simple queries as well as scripts. Executing scripts the result will be shown in a text pane.

Execute Groovy Scripts

From the editor menu you can choose the Groovy language. Scripts can be edited and executed.

Text Auto-complete

From menu you have the option of formatting SQL queries.

Multiple result panes

You can create multiple result panes to show the results.

Save editor text in project file

The edited text is saved in the project file. Reopen the project and from the SQL Editor menu you can access the previous created queries.

Save result to file

In the Result Pane you have the option to save the result to file. You can also enter the spool mode, which is useful for large results. In this case the result won't be displayed on the screen, but pushed directly to a file you will choose. The advantage is that the result won't be paged, as on the screen, but completely written to file.

Explain Query Execution Plan

This feature is being implemented only for some of the databases. Using it you have a better representation of the query execution plan tree. On the left you can see the original execution plan, as delivered from the database. On the right is the time-line representation of the plan, so you can see which step is executed at which point in time.

Spool Result To File

In the Result Pane you have the option to save the result to file. You can also enter the spool mode, which is useful for large results. In this case the result won't be displayed on the screen, but pushed directly to a file you will choose. The advantage is that the result won't be paged, as on the screen, but completely written to file.

Navigation