Condition for Creating Updatable VIEW

Description

To update data in a virtual table, it must be updatable because an option is needed to define data.

A virtual table is updatable if it satisfies the following conditions:

Even when all rules above are satisfied, each column of the a view may not be updatable. The following columns cannot be updated:

Even though the column defined in the view is updatable, a view can be updated only when an appropriate update authorization is granted on the table included in the FROM clause.  Also there must be an access authorization to a view. The way to grant an access authorization to a view is the same to grant an access authorization to a table. For details on granting authorization, see "Granting Authorization.