Re: When to use Updateable View ?

From: DA Morgan <>
Date: Sat, 30 Sep 2006 22:04:29 -0700
Message-ID: <>

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
Received on Sun Oct 01 2006 - 00:04:29 CDT

Original text of this message