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:
- Click the text cursor within the statement in the Java editor.
- Right-click the statement.
- 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.