Reality …
Those rules are as liberal as possible. Most actual systems require the following of a view definition for it to be updateable:
- No GROUP, DISTINCT, UNION, MINUS, INTERSECT, or arithmetic
- Update must be resolvable to specific rows in exactly one of the base tables involved in the view.
- For deletion, only single-table views are updateable.