To define a query:
In
the Query window, click in the Icon
Bar to display the Select Data Tables dialog box.
Double-click the table(s) from which you want to retrieve data (or select a table and click Include) to move it into the Query window. To include a range of tables, hold down the SHIFT key while clicking the first and last tables in the range.
If
you need to link a table to itself, select the table again.
Note: If you include the same table more than once in a query, duplicate
tables are automatically assigned system-generated alias names composed
of the name for the base table, followed by an underscore and a number.
When all the tables have been selected, click Close.
Select each column (either select the check box next to the column, or double-click the column name). To include all the columns, check the check box in the table title bar. Note: When you select a column object from a table, Query Builder automatically uses the table alias in your query. Likewise, if you include a column object in the Condition field and accept the condition, Query Builder automatically inserts the appropriate table aliases into your condition.
(Optional) Add one or more conditions to refine your query.
(Optional) Create relationships.
Click OK to generate the SELECT statement.
Data source object notation in the Query window (Query Builder)
Displaying a query's SQL statements (Query Builder)
Sorting query data (Query Builder)
Displaying information and comments on tables and columns (Query Builder)
Controlling join conditions in linked queries (Query Builder)
Renaming a table (Query Builder)
Removing a table from a query (Query Builder)
Creating a defined column (Query Builder)
Deleting a defined column (Query Builder)
Changing column order (Query Builder)
Changing the sort order (Query Builder)
Deleting a sort column (Query Builder)
Creating an unmatched relationship (Query Builder)
Removing unmatched rows (Query Builder)
Activating and deactivating a relationship (Query Builder)
Creating a composite relationship (Query Builder)
Creating a self-relationship (Query Builder)
Creating a simple relationship (Query Builder)
Deleting a relationship (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.