Title: Create a view.
Course: Database Design and Management (Oracle) (10052) > Section: Creating and Managing Views

Creation of a view consists of using the keywords CREATE VIEW and the full syntax (Syntax in the square brackets is optional):

CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view
[(alias[, alias]...)]
AS subquery
[WITH CHECK OPTION [CONSTRAINT constraint]]
[WITH READ ONLY [CONSTRAINT constraint]];