CREATE [OR REPLACE] VIEW [{FORCE | NOFORCE}] view_name
AS subquery
[WITH {CHECK OPTION | READ ONLY} CONSTRAINT cons_name];
FORCE -- the view can be created even the base tables doesn't exist.
WITH CHECK OPTION -- only rows can be retrieved by the subquery can be inserted, updated or deleted