Previous Topic: Rules for InsertingNext Topic: Example 1


Processing

Rows can be inserted that do not conform to the definition of a view. These rows cannot appear in the view, but are inserted into the base table of the view.

Unless appropriate locks already exist, one or more exclusive locks are acquired at the execution of a successful INSERT statement. Until the locks are released, an inserted row can be accessed only by the unit of recovery in which the insert was performed.