- 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)
Monday, August 16, 2010
Oracle 11g: Rules For Performing DML Operations On a View
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment