Monday, August 16, 2010

Oracle 11g: Rules For Performing DML Operations On a View

  • can always perfrorm DML operations om simple views
  • cannot remove a row, if view contains:
    • Group Function
    • Group By
    • Distinct
    • RowNum
  • cannot add data thru view, if view contains:
    • Group Function
    • Group By
    • Distinct
    • RowNum
    • Parent table that has columns - not null 
  • cannot modify data in view, if view contains
    • Group Function
    • Group By
    • Distinct
    • RowNum
    • Expressions (case when, decode) 

No comments: