About Query Builder

The Query Builder page is divided into three sections:

Object Selection pane displays on the left side of the page and contains a list objects from which you can build queries. Only objects in the current schema display. To select another schema, make a selection from the Schema list.
Design pane displays to the right of the Object Selection pane and above the Conditions, SQL, Results, and Saved SQL tabs. When you select an object from the Object Selection pane, it appears in the Design pane.
Output pane displays below the Design pane. Once you select objects and columns, you can create conditions, view the generated SQL, or view query results.

Topics:

Accessing Query Builder

To access Query Builder:

Log in to Oracle HTML DB.
Click the SQL Workshop icon on the Workspace home page.

The SQL Workshop home page appears.
To view Query Builder you can either:
- Click the Query Builder icon.
- Click the down arrow on the right side of the icon to view a pull-down menu. Then, select the appropriate menu option.
Note:
For the purposes of consistency, this document uses the primary navigation path (or drill-down approach) when explaining navigation.

To build a a query in Query Builder, you perform the following steps:

Select objects from the Object Selection pane. See "Using the Object Selection Pane" .
Add objects to the Design pane and select columns. See "Selecting Objects".
Optional: Establish relationships between objects. See "Creating Relationships Between Objects".
Optional: Create query conditions. See "Specifying Query Conditions".
Execute the query and view results. See "Viewing Query Results".