Use the Eclipse launch configuration mechanism to run an ad hoc
SQL query.
PrerequisitesÂ
Make sure that the database server is
running. Establish a connection to the database through a connection profile.
-
Select
.
-
In the
Main tab, click Adhoc SQL.
-
Select the
connection Profile and Database.
-
In the
Run box, enter the SQL query, or click SQL to graphically build the SQL statements in SQL Query Builder.
-
In the
Run box, enter the SQL query, or click SQL, select the statement type, and then complete building the SQL statement using Visual SQL.
-
Click
Run to execute the query.
You can view the
results of the ad hoc query in the SQL Results view.