SQL Editor

Edit Queries

Using the SQL Editor you can edit and execute queries.

Auto-complete

Press CTRL-BLANK to activate the auto-complete popup.

Auto-format queries

From menu you have the option of formatting SQL queries.

Execute scripts

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

Multiple result panes

You can create multiple result panes to show the results.

Write 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 completly written to file.

Explain 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.