# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1685818596

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Create a view.

Definition

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]];