Can you update a view in a database? If so, how? If not, why not?
Can you update a view in a database? If so, how? If not, why not?
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.