Is a view in the database updatable?

Viewed 17991

Can you update a view in a database? If so, how? If not, why not?

12 Answers

We generally don't update a view. A view is written to fetch data from the various tables based on joins and where conditions put.

View is just a logic put in place which gives the desired data set on invoking it.

But not sure on what scenario one needs to update a view.

Related