Re: When to use Updateable View ?

HansF wrote:

> A view should represent a business access to the data. For example the
> view might provide the complete purchase order information, rather than
> the 'purchase order header' and 'line items' normalized tables.

Perhaps we read the OP's question differently but a view as you describe would not normally be updatable without the use of an INSTEAD-OF trigger.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group