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

Subquery restriction [Oracle SQL clause]

with read only
or 
with check option [ constraint constraint-name ]
The subquery restriction clause appears as part within the create view statement.