Shown below is an example of two tables in the Query window's Data Source panel, linked by a relationship.
Click any icon, indicator, or part of these objects to display a description:
The icon in the upper left corner of any data source object indicates its type:
Table
View
Query
Snapshot
Synonym
This is the name of the data source object. You can change the name by clicking on the object title.
This icon indicates that this object (or column) has a comment associated with it. Double-click this icon to open the Info dialog box, where you can view the comments.
A column name displayed in boldface indicates that this column has been defined as a primary key for the object.
The following icons indicate the datatypes of their respective columns.
|
If you click and hold on one of these icons, a pop-up menu appears, and you can choose a different datatype.
|
This is the name of one of the columns in this object. If you double-click a column name, the column will be included in your query.
A column name displayed in italics indicates that this column is a foreign key, related to a primary key in another column. Setting up a relationship between two columns is the only way to define a foreign key.
This icon indicates that a self-relationship has been created between this column (foreign key) and another column (primary key) in the same table.
A gray line drawn between two columns indicates that a relationship has been created between the columns at either end of the line. The line is drawn from the foreign key to the primary key.
Datatype icons (Query Builder)
About Query Builder relationships
Copyright © 1984, 2005, Oracle. All rights reserved.