Executing SQL Statements

How to Run Execution

Entire Script

To execute the entire script, click Execute on the SQL toolbar.

Alternatively, on the SQL menu, click Execute.

Selected Block of Text

To execute an arbitrary text block, do the following:

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

  2. Run the Execute command as when executing the entire script.

Current Statement

To execute the current statement, click Execute Current Statement on the SQL toolbar.

Alternatively, right-click a required statement, and select Execute Current Statement on the shortcut menu.

Execute to Cursor

To execute a script to the statement (including this statement) where the cursor is currently positioned, do the following:

  1. Move the cursor to the required position (any place in the statement).
  2. On the shortcut menu, click Execute to Cursor or press Ctrl+Shift+F10.

How to Stop Execution

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

Representing Query Execution Results

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

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

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