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.

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

Description of the illustration qry_bldr.gif

Selecting a Schema

A schema is a logical container for database objects. To access objects in another schema, make a selection from the Schema list in the upper right side of the page.

Switching to Another SQL Workshop Component

You can navigate to another SQL Workshop component by selecting one of the following from the Component list located on the upper right side of the page:

• Object Browser. See "Managing Database Objects with Object Browser".

• SQL Commands. See "Using SQL Commands".

• SQL Scripts. See "Using SQL Scripts".

• Query Builder. See "Building Queries with Query Builder".

Topics:

• Accessing Query Builder

• Understanding the Query Building Process