Create views

Use the CREATE VIEW command to define a view of a table. The view is not physically created, but rather the RDBMS automatically generates a query rewrite to support SELECT operations on views.

To create a view, enter:

   MYDB.SCHEMA(USER)=> CREATE VIEW viewname AS SELECT query;