Manipulation of DML commands through a view is executed using the following rules:
- A row may not be removed if the view contains
-
-
- group functions
- a GROUP BY clause
- the DISTINCT keyword
- the pseudocolumn ROWNUM keyword.
- Data may not be modified in a view if it contains
-
-
- group functions
- a GROUP BY clause
- the DISTINCT keyword
- the pseudocolumn ROWNUM keyword
- columns defined by expressions.
- Data may not be added through a view if the view includes
-
-
- group functions
- a GROUP BY clause
- the DISTINCT keyword
- the pseudocolumn ROWNUM keyword
- columns defined by expressions
- NOT NULL columns in the base tables that are not selected by the view.