CREATE VIEW

Create a view.

Syntax:

   CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW
     [schema.]view [(alias,...)]
         AS subquery options

Syntax: (Object Views)

   CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW
     [OF [schema.] type_name
        [WITH OBJECT IDENTIFIER {DEFAULT|(attribute,...)}]
            AS subquery options

options:
   WITH READ ONLY
   WITH CHECK OPTION [CONSTRAINT constraint]

"Never hold discussions with the monkey when the organ grinder is in the room" - Winston Churchill

Related Commands:

ALTER VIEW
DROP VIEW

Related Views:

 DBA_VIEWS            ALL_VIEWS            USER_VIEWS
 DBA_MVIEWS           ALL_MVIEWS           USER_MVIEWS

 V$FIXED_VIEW_DEFINITION 
 V$RESERVED_WORDS