I've been looking and can't find anywhere that list the benefits of using an updatable view (one that can be modified with the modifications affecting the target table).
I understand why materialized views are useful (speed, security, etc) but since updatable views can't contain joins and other useful optimizations...
Can anyone list why they might be useful? I'm sure Oracle has a good reason for implementing them.
Updateable views can indeed contain joins. They must also have constraints so that an update cannot be ambiguous - every value updated must be guaranteed not to be updated to multiple values.