Swapnil

• Jul 28th, 2005

 

an Insert,Update,delete can be done through views is 
1. inserts/updates/deletes done only in one base table at a time 
2. primary key columns should be part of view 
3. columns which are going to be updated must be part of vew def. 
4. it shouldn't voielet the contraints

Sandipanni Bharadwaj

• Aug 10th, 2005

 

5. The query of the view shoud not consist of any aggregate funtion  
6. The query shoud not consist of any subquery 
7 And the other option is we can use the instead of trigger to update the Table/s based up on the dml operation issued over the view. so that the modified data will be reflected in the view.