we can update view .if the view is created with one table.
But we canot update view if the view is created with more than one table with multiple columns.why because view is single virtual table created multiple columns from diffrent tables. so we canot update this virtual table i.e view.when we selected multiple tables and mutiple columns.
yes views can be updated only if all elements of view are subset of the base table.suppose base table is having empid name and addr colmns then a view on this table created as
create view myview as select * from emp; only these type of views are updatable.
create view myview as select name addr from emp; is not updatable.
Yes Views are updatable based on conditions it can be a single table having unique records based on primary key values or it can be multiple table linked with primary key values where updation of view should yield a unque recordset from the two tables .
Hi we cannot update view but we can create or replace a view. we cannot update its defination. we can update a underlying base table through a view under certain conditions i.e. only one table based view no grouping etc.
First of all a view is not part of a table as a gentleman here explained. A view is a virtual table meaning it does not exist as a table. Yes a view is an schema object but it is only as such view . It is a view of a table ot joined tables. If you are updating a field from a view you are not updating the view but the table which that view is based upon. No you cannot update a view only the table a view is based upon.
0 
1