Create a view.
CREATE [OR REPLACE] VIEW <view-name> AS <select-statement>;
| ||Name of the view.|
| ||The select statement to use for the view.|
view-name may optionally be qualified with a schema.
OR REPLACE is specified and a view with
view-name already exists, the view’s definition will be replaced with the new
Create a view named
simple_select that selects the value “1”.
CREATE VIEW simple_select AS SELECT 1;