Home > DeveloperSection > Interviews > Are views updateable ?

Posted on    March-28-2011 7:07 AM

 DB2 DB2 
 1 Answer(s)
  1168  View(s)
Rate this:

Mahesh Rawat
Mahesh Rawat

Total Post:138

Posted on    March-28-2011 12:00 AM

Not all of them. Some views are updateable e.g. single table view with all the fields or mandatory fields. Examples of non-updateable views are views which are joins, views that contain aggregate functions(such as MIN), and views that have GROUP BY clause.

Don't want to miss updates? Please click the below button!

Follow MindStick