Oracle视图更新要求

You can perform DML operations on simple views.
You cannot remove a row if the view contains the following: (delete)
·Group functions
·A GROUP BY clause
·The DISTINCT keyword
·The pseudocolumn ROWNUM keyword

You cannot modify data in a view if it contains: (update)
·Group functions
·A GROUP BY clause
·The DISTINCT keyword
·The pseudocolumn ROWNUM keyword
·Columns defined by expressions

You cannot add data through a view if the view includes: (insert)
·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