Use the CREATE VIEW
command to create a non-materialized view, which runs every time the view is referenced in a query. A non-materialized view can be created based on sources, tables, views, or indexes.
Parameter | Description |
---|---|
mv_name | The name of the view to be created. |
column_name | Specify the columns of the view. |
select_query | A SELECT query that retrieves data for the view. See SELECT for the syntax and examples of the SELECT command. |
v3
.