A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.

Maheswara Raju. Varakavi

• Aug 29th, 2016

If a view is updated, deleted , or inserted will the changes be reflected on the base table? YES--> If it is in the case of simple view (which consists only one base table). NO---->If it is in the c...

Mahendra K Garnayak

• Jun 7th, 2016

Thanks M.R. Varakavi for providing a valuable information.
could you please confirm in instead of trigger action will be performed on which table in case of join condition

Answer Question  Select Best Answer