Relationships that you create using the mouse are automatically activated and deactivated as they are needed in a query. Active relationships are displayed with a heavy black line; inactive relationships are shown as grey lines.
To manually activate a relationship using the mouse:
To deactivate a relationship:
About Query Builder relationships
Creating a composite relationship (Query Builder)
Creating a self-relationship (Query Builder)
Creating a simple relationship (Query Builder)
Creating an unmatched relationship (Query Builder)
Deleting a relationship (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.