• In general, no updates are supported on views derived from more than one base table.

• You cannot update columns that are in the where clause of the view definition.

• You can only update simple columns from the target_list of a view definition; you cannot update columns that are not simple columns (such as aggregates, derived columns, or constants).

• You cannot update a row with a value that causes the row to be dropped from the view.

• You can only define views based on tables for which you have retrieve permission.

• When you destroy a table that is referenced by a view, the DBMS Server automatically destroys the view.