CODEWITHSUNDEEP
sqloracle-databaseviewupdatable-views
DanielST
DanielST

Reputation: 14133

What is the use of updatable views in Oracle SQL?

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.

Upvotes: 1

Views: 499

Answers (1)

David Aldridge
David Aldridge

Reputation: 52376

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.

Upvotes: 2

Related Questions