Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 GroupReceived on Sun Oct 01 2006 - 00:04:29 CDT
![]() |
![]() |