next up previous
Next: Creating and Destroying Indexes Up: Views Previous: Corresponding Base Relations

View Updates Might Not Make Sense

If TOTAL_SAL is defined to be the sum of individual employee salaries, what does a view update changing TOTAL_SAL mean? 

 
UV2: 		 MODIFY  		 DEPT_INFO


		 SET 		 TOTAL_SAL= 100000


		 WHERE 		 DNAME=`Research'

Larry Latour
Sun Oct 27 22:51:12 EST 1996