Ramesh P

• Jul 7th, 2005

 

A view can deleted/Inserted/updated

J Lehew

• Aug 25th, 2005

 

There are restrictions since a view can join multiple tables and have functions and groupings it may not be possible to update a view. Simple views on one table can definately be updateable.

Venu.

• Nov 24th, 2005

 

A simple view can be updated/inserted/deleted but the complex view which is constructed by using multiple tables or by using group functions can't be updated/deleted/inserted directly for that we have to write instead-of-triggers. 

narasimhulu

 Profile Answers by narasimhulu 

• May 31st, 2006

 

Yes a view can be updated/inserted/deleted only if it is based on single base table means it should be a simple view.

Srikanth

• Nov 7th, 2006

 

a view can be manpulated by using instead of triggers

sweetytrivedi

 Profile Answers by sweetytrivedi 

• Jun 24th, 2008

 

If a view is based upon a single table then DML operations can be performed on it, while if a view is based upon more than two tables then it is a complex view and DML operations can be performed using instead of triggers.