Create a view on a table in a table hierarchy
You can create a view based upon any table in a table
hierarchy. For example, the following statement creates a view on
the person table, which is the root supertable of the table
hierarchy that Example of the relationship
between type hierarchy and table hierarchy shows:
CREATE VIEW name_view AS SELECT name FROM personBecause
the person table is a supertable, the view name_view displays
data from the name column of the person, employee,
and sales_rep tables. To create a view that displays only data
from the person table, use the ONLY keyword, as the following
example shows:
CREATE VIEW name_view AS SELECT name FROM ONLY(person)Restriction: You cannot perform an insert or update on a view
that is defined on a supertable because the database server cannot
know where in the table hierarchy to put the new rows.
For information about how to create a typed view, see Typed views.