Running Queries in SQL Developer

This topic explains how to run queries or other SQL statements in SQL Developer, if you are connected to Oracle Database as user HR from SQL Developer (for instructions, see "Connecting to Oracle Database as User HR from SQL Developer").

To run queries in SQL Developer:

1. Click the icon SQL Worksheet.

   Either the Connection Information window opens or the SQL Worksheet pane appears.

2. If the Select Connection window opens:

   1. If the Connection field does not have the value hr_conn, select that value from the drop-down list.

   2. Click OK.

   The SQL Worksheet pane appears. Under "Enter SQL Statement:" is a field where you can enter a SQL statement.

3. In the SQL Worksheet pane, type a query (a SELECT statement).

4. Click the icon Execute Statement.

   The query runs.

5. Click the tab Results.

   The Results pane appears, showing the result of the query.

6. Click the icon Clear.

   The query and its results disappear, and you can enter another SQL statement in the SQL Worksheet.