Suppose I have created a view from more than 1 table. There is also a where claues in the select query of the view. Now I am updating all the data of a particular column of the View. Is it possible in this condition?
If updation is possible then is it reflect in the main table data?
what happen to those data are that are not in where clause in main table? Is this updation occur to those data?