Query Tool

SQL statements can be carried out within the relevant database, without having to revert to other external database query systems. The Query Tool executes a set of arbitrary SQL statements. If an error is encountered during execution, the modifications produced by INSERT, UPDATE and DELETE statements are rolled back.

The query execution page has parameters that require input to execute a query.

Use the Browse File button to browse the Work Area. Select the SQL File and click Execute to execute.

SQL statements can be typed in the text area space for Query, however, total number of characters should not exceed 100,000 and statements must be separated by semicolons ( ; ).

Achtung

If there are several SELECT statements, only the last one will be inserted in the Query text area and executed.

The default Result Size 100 can be changed by selecting the new values as applicable.

Click the History button to view the Query History. Click the Execute button to execute or the Clear button to clear the typed SQL statements.

At the end of the result list you can export the result as Excel or CSV.