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
CREATE TYPE - Create Objects

Related Views:

 DBA_VIEWS            ALL_VIEWS            USER_VIEWS

 V$FIXED_VIEW_DEFINITION 

 Materialised views: DBA_MVIEWS




Back to the Top

Simon Sheppard
SS64.com