Testing the SQL Statement

Procedure

  1. Right-click anywhere in the Outline pane and select Run SQL.
  2. If your query defines any input variables (conditions defined in the ’?’), the Host Variable Values dialog is displayed, in which you can enter values for each variable.

Result

The SQL Results view is displayed. This contains two panes:

  • The left-hand pane shows the status of each SQL statement that you have run in this session.
  • The right-hand pane shows the status and results (in separate tabs) of the query that is currently selected in the left-hand pane.

    .

    Tip: If you want the right-hand pane to display just the results, on a single tab, click