Enterprise Manager - Database: Views
To view this topic for the preceding Enterprise Manager, see EM Java App: Database - Views Tab.
Views allow the database administrator to create "views" of the database that appear to the user as another table, but can be arbitrarily complex in the information they present.
To create a view
1. Select the desired database from the "Databases" list.
2. Click on the Views tab.
3. Click on the [Add New View] button.
To edit a view
1. Select the desired database from the "Databases" list.
2. Click on the Views tab.
3. Select the appropriate view from the list.
4. Click on the edit view button or double-click the View Name.
The view editor dialog is very simple and contains two items: name, and SELECT statement. The name of the view is the name that users will use when they want to refer to the view in a query. The SELECT statement is the query that will be run when users refer to the view. For example:
The OPENINV view shown above performs a join between two tables and includes a WHERE clause. A user accesses this view using a simple SELECT statement:
SELECT * FROM openinv
When this statement is executed, internally it executes the view statement and treat its results as if it were a single table.
See Also
Metadata Definition