René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

create view [Oracle]

create [ or replace ] [ [ no ] force ] view view-name (
   alias-1 [ inline-constraint-1 ]
   ...
 [,alias-1 [ inline-constraint-n ]
)
as subquery subquery-restriction-clause

create [ or replace ] [ [ no ] force ] view view-name 
object-view-clause
as subquery subquery-restriction-clause

create [ or replace ] [ [ no ] force ] view view-name 
xmltype-view-clause
as subquery subquery-restriction-clause