Offline database views can be modeled graphically on a database diagram. The tables and views on which this view is to be based have to be present either on the diagram, or in the same project as the database diagram.
To visualize a view on a diagram:
About Database Modeling
How to Read a Diagram of Modeled Tables
Getting Started with Database Modeling
Modeler's Guide
Copyright © 1997, 2004, Oracle. All rights reserved.