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 pureQuery > 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.