The data dictionary views ALL_UPDATABLE_COLUMNS, DBA_UPDATABLE_COLUMNS, and USER_UPDATABLE_COLUMNS indicate which view columns are updatable.
An updatable view lets you insert, update, and delete rows in the view and propagate the changes to the target master table.
Views can provide advantages over tables: Just as a function (in programming) can provide abstraction, so can a database view.
In another parallel with functions, database users can manipulate nested views, thus one view can aggregate data from other views.
By using these operations, you can perform simple SQL INSERT, UPDATE, SELECT, and DELETE statements qualified by a WHERE clause on the target table (or view).