What is updatable view?

Question

An updatable view is a special case of a deletable view. A deletable view becomes an updatable view when at least one of its columns is updatable. A column of a view is updatable when all of the following rules are true: The view is deletable.

What is updatable view in SQL?

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

What is updatable view in Oracle?

An updatable view is one you can use to insert, update, or delete base table rows. You can create a view to be inherently updatable, or you can create an INSTEAD OF trigger on any view to make it updatable.

What is updatable view and non updatable view?

It means that the server always knows whether a view is updatable. If a view is not updatable, statements such UPDATE , DELETE , and INSERT are illegal and are rejected. (Even if a view is updatable, it might not be possible to insert into it, as described elsewhere in this section.)

How do you make a updatable view?

However, to create an updatable view, the SELECT statement that defines the view must not contain any of the following elements:1Aggregate functions such as MIN, MAX, SUM, AVG, and COUNT.2DISTINCT.3GROUP BY clause.4HAVING clause.5UNION or UNION ALL clause.6Left join or outer join.

Expert · Answer