Running SQL statements from the Java editor

You can test SQL statements by running them from the Java editor.

Before you begin

A connection to the database that you want to run the SQL statement on must be defined in the Data Source Explorer and associated with your Java project.

Procedure

To run an SQL statement:

  1. Click the text cursor within the statement in the Java editor.
  2. Right-click the statement.
  3. Select Data Access Development > Run SQL.

Results

When you run an SQL statement, the results of the statement appear in the SQL Results view in the workbench. This view opens automatically if it is not already open.

Feedback