# Running an Ad Hoc SQL Statement

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.

1. Select Run > Open Run Dialog Run > Run Configurations .
2. In the Main tab, click Adhoc SQL.
3. Select the connection Profile and Database.
4. In the Run box, enter the SQL query, or click SQL to graphically build the SQL statements in SQL Query Builder.
5. 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.
6. Click Run to execute the query.

You can view the results of the ad hoc query in the SQL Results view.
Related tasks
Executing a SQL File
Executing a SQL Statement
Viewing SQL Results