tell me more icon Creating an Offline Database View

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.

database diagram

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 icon View component onto the diagram.

Edit View dialog

Copyright © 1997, 2009, Oracle. All rights reserved.

false ,,,,,,,,,,,,,,,