Re: When to use Updateable View ?
Date: Sat, 30 Sep 2006 22:04:29 -0700
> 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 GroupReceived on Sun Oct 01 2006 - 00:04:29 CDT