Strategies for Object Views:

Here are some of the things which should guide your thinking about object views:

Since of their ability to tolerate schema modifies, object views can gives benefits over conventional objects. (when compared against object tables)What is unclear is the degree of performance impact they might cause.

Unless you have a very good reason to do or else define the OID of an object view to be a unique value.

Adopt a consistent approach in the localization of DML on object views. The statement INSTEAD OF triggers is cool but triggers can exhibit confusing interactions with each other. The Packages might still be the optimal construct in that to define insert, delete, and update logic.