Title: (Optional) Manipulate tables, using the INSERT, UPDATE, and DELETE commands through a view.
Course: Database Design and Management (Oracle) (10052) > Section: Creating and Managing Views

Manipulation of DML commands through a view is executed using the following rules:

1. A row may not be removed if the view contains
  - group functions
  - a GROUP BY clause
  - the DISTINCT keyword
  - the pseudocolumn ROWNUM keyword.
2. 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.
3. 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.