3 Updatable and Insertable Views. Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements such as UPDATE , DELETE , or INSERT to update the contents of the underlying table.

What does it mean for a view to be updatable?

Update View

An updatable view is one which allows performing a UPDATE command on itself without affecting any other table.

What is the purpose of creating view?

Views can be used as a security mechanism

A view can select certain columns and/or rows from a table (or tables), and permissions set on the view instead of the underlying tables. This allows surfacing only the data that a user needs to see.