CREATE VIEW

Create a view.

Syntax:

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

Object View:
   CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW
     [OF [schema.] type_name
        {WITH OBJECT IDENTIFIER {DEFAULT|(attribute,...) |
        UNDER SCHEMA.superview }
        ([out_of_line_constraint(s)]
            attribute inline_constant(s))
            AS subquery options

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

XMLType_view_clause:
   OF XMLTYPE [XMLSCHEMA XMLSchema_URL] ELEMENT element
     WITH OBJECT IDENTIFIER {DEFAULT | (expr,...)}

   OF XMLTYPE [XMLSCHEMA XMLSchema_URL] ELEMENT XMLSchema_URL#element
     WITH OBJECT IDENTIFIER {DEFAULT | (expr,...)}

"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