SQL editor
Highlight and autocomplete in the SQL editor
The SQL editor is highlight enabled. The table names and the database specific keywords are highlighted.
You can change the color scheme from the configuration dialog.
The autocomplete feature helps you typing the table or column names. The feature is available by pressing
CONTROL + SPACE. To use this feature for the column names, please type in first the table names.
Execute SQL; simple or script execution
The SQL phrases may be executed by selecting them and pressing the EXECUTE button ( F8 ).
The normal execution will paginate the result, if the result is large.
You can use the top-right buttons to navigate to a different page.
There are two execution modes: as single query or as a script. The execution as a script can
execute mutiple queries at a time. The output is displayed into a text pane.
Use multiple result panes
By pressing one of the execute buttons using the right mouse button, a new result pane will open each time.
Otherwise the current result pane will be used.
Other features
- Using the SQL editor you can also do 'Explain plan' to debug SQL statements.
- You can output the result to a file on disk, comma separated, tab separated or as XML
- You can execute 'DESC table_name;' to describe a table
