Deepak Verma
Are all views updatable ?
By Deepak Verma in SQL Language on Apr 14 2011
  • Pankaj  Kumar Choudhary
    Mar, 2015 29

    if any view contain join, aggregate fun then we can not update that view......

    • 0
  • Deepak Verma
    Apr, 2011 14

    No,

    We can update some views (for e.g. single table view with all the fields or mandatory fields).

    And we can't update views which are joins, views that contain aggregate functions, and views that have GROUP BY clause.

    • 0