title: Can a view be updated/inserted/deleted? If Yes under what conditions?
body: <p>I googled above question and got the following answers</p>
  
  <p>YES--> If it is in the case of simple view (which consists only one base table).</p>
  
  <p>NO---->If it is in the case of complex view( which consists multiple base tables, and joins).</p>
  
  <p>However, there is an indirect way of performing DML operations on Complex views, by using "Instead Of trigger". In the body of Instead of trigger we will use co-relational identifiers, and DML statements to perform DML operations indirectly on the complex view. Then that changes will reflect in base tables of that particular complex view.</p>
  
  <p>here my question is does changes applied to view will have any effect on original tables?</p>
  
  <p>If a View on a single base table is manipulated will the changes be reflected on the base table?</p>
  
  <p>can any one give me example for the above cases?</p>