NOTES ON ORACLE SQL | SQL PAPER-1Z051 | 11G

VIEWS

You cannot delete the row if the view contains the following :

--Group functions
--A GROUP BY clause
--The DISTINCT keyword
--The pseudocolumn ROWNUM keyword

You cannot modify the data in the view if it contains:
--Group functions
--A GROUP BY clause
--The DISTINCT keyword
--The pseudocolumn ROWNUM keyword
--Columsn with expressions

You cannot add  data thru the view if it contains:
--Group functions
--A GROUP BY clause
--The DISTINCT keyword
--The pseudocolumn ROWNUM keyword
--Columsn with expressions
--NOT NULL columns in the base tables whcih are not selected by the view.

View with CHECK OPTION
VIEW with READ ONLY