Typed Views
You can create typed views if you have Usage privileges on the named-ROW type or if you are its owner or the DBA. If you omit the OF TYPE clause, rows in the view are considered untyped and default to an unnamed-ROW type.
Typed views, like typed tables, are based on a named-ROW type.
Each column in the view corresponds to a field in the named-ROW type.
The following statement creates a typed view that is based on the
table person.
CREATE VIEW v2 OF TYPE person_t AS SELECT * FROM person;
To create a typed view, you must include an OF TYPE clause. When you create a typed view, the named-ROW type that you specify immediately after the OF TYPE keywords must already exist.