Executing SQL Statements

How to Run Execution

Entire Script

To execute an entire script, click the Execute Large Script button on the toolbar Execute script button

Alternatively, select the Execute command on the SQL menu.

SQL menu

Selected Block of Text

To execute an arbitrary text block:

  1. Select the text block using a mouse or a keyboard.

  2. Click the Execute button on the toolbar Execute button

Alternatively, select Execute Selection from the shortcut menu of SQL Editor.

Current Statement

To execute a current statement, select the Execute Current Statement from the shortcut menu of SQL Editor.

Alternatively, Click the Execute button on the toolbar Execute button

How to Stop Execution

To stop SQL execution, click Stop Execution the SQL toolbar.

Representing Query Execution Results

The query execution results can be represented in two ways: in a text and in a grid formats.

To represent results as a text, click Results as Text on the SQL toolbar before query execution.

To represent results as a grid, click Results as Grid on the SQL toolbar before query execution.

Query execution options

If you want to check or set query execution options right-click the SQL query and select Query Execution Options.

Query execution options