Title: 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.

1. 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.

1. 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.