Views are virtual tables based on the result-set of a
SELECT statement that lets you combine tables and present the data as if the data were coming from a single table. You can add SQL Functions, Joins, WHERE, GROUP BY, ORDER BY, or HAVING clauses to a view, to present exactly the data you want to the user.
You will create and edit a view both diagrammatically using a database diagram, and declaratively using the Edit View dialog, shown below. To begin creating a view, you will drag and drop a View component onto the diagram.
Copyright © 1997, 2009, Oracle. All rights reserved.