When you open a query, Query Builder displays it in the Query window, which includes:
the Conditions panel, where the Condition field is located. It is used to refine the query.
the Data Source panel, which displays the tables (views, snapshots, and so forth) used in the query.
the Icon bar, which includes icons for defining your query.
Depending on your preferences, the panels may be split vertically or horizontally.
Each table is displayed in a box containing the name of the table and the names of columns in that table. There are a number of icons that help identify the current database object. The icons indicate whether descriptive comments are attached, the type of data source, the column's datatype, and whether indexes have been defined for tables in the query.
Lines are drawn to indicate the relationships between columns. Relationships are set up between tables to identify how a column in one table relates to a column in another table.
A check mark to the left of the column name indicates the column has been included in the query. This means that Query Builder will search for data corresponding to the column name when you run the query. No check mark indicates that column's data will not be included.
The Conditions panel is the left-hand section of the Query window that contains the Condition field, where you enter expressions and conditions. Query Builder conditions automatically generate WHERE or HAVING clauses, as appropriate. You can size the Conditions panel as desired.
The table and column names indicate which columns will be filtered in the condition. You may omit the table name if the column name is unique.
Note: When you activate the
Condition field, the cursor will have a (+) sign, indicating that any
item you click on will be added to your condition. To deactivate this,
you can click in the Icon bar.
The Data source panel is the right-hand section of the Query window where items, such as tables and relationships, display.
The Icon bar displays at the top of the Query window. click each icon to view a description.
Saves your query to the specified file.
Cuts the selected text and places it on your operating system's clipboard.
Copies the selected text onto your operating system's clipboard while the original text remains intact.
Pastes the current clipboard items into the active location. If there is nothing on the clipboard, nothing will be pasted. You can paste any text that you have cut or copied.
Removes the selected item (that is, text, table). Unlike the Cut command, Clear does not place the removed item(s) on your operating system's clipboard.
Selects every item in the active window. For example, if the Conditions panel is active, all conditions in the panel will be selected.
Displays the Select Data Tables dialog box.
Displays the Select Related Tables dialog box. This icon is available only when the table you have selected has a related table in the connected database.
Displays the Rename Table dialog box. This icon is available only when there is at least one table in the Query Builder workspace.
Displays the Info dialog box and information on the selected database object. This icon is available only if a data source object is active.
Displays the Set Relationship dialog box. This icon is available only when there is more than one table in the Datsource panel to relate.
Displays the Show SQL dialog box and the SQL for the active query.
Displays the Display dialog box.
Displays the Define Column dialog box.
Displays the Sort dialog box.
Inserts the AND operator into your condition. This icon is available only when the Condition field is active. You can also type AND directly into the Condition field.
Inserts the OR operator into your condition. This icon is available only when the Condition field is active. You can also type OR directly into the Condition field.
Inserts the NOT operator into your condition to negate your condition. This icon is available only when the Condition field is active. You can also type NOT directly into the Condition field.
Ungroups conditions that are combined with logical operators, such as AND, OR, NOT. This icon is available only when you have selected a logical operator in the Conditions panel.
Validates and accepts the active condition. This icon is available only when the Condition field is active. You can also press the Enter or Return key when the Condition field is active to accept and validate your condition.
Cancels the current condition. This icon is available only when the Condition field is active.
Displays the Paste Column dialog box. This icon is available only when the Condition field is active.
Displays the Paste Function dialog box. This icon is available only when the Condition field is active.
Copyright © 1984, 2005, Oracle. All rights reserved.