Re: Creating Views

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 24 Aug 1999 09:27:35 -0400
Message-ID: <37C29DC6.7AF1CC4@Unforgettable.com>

Jurij Modic wrote:

> On Mon, 23 Aug 1999 08:15:32 -0400, Kenneth C Stahl
> <BluesSax_at_Unforgettable.com> wrote:
>
> >You cannot insert into a view that is defined with a join.
>
> Yes you can, if you are using Oracle8 or 8i. "INSTEAD OF" triggers
> were introduced in 8.0 to allow modification of joined tables through
> views.
>
> >Ken
> any official standpoints of my employer

Whoops. Didn't realize that 8 had made that change. I'm still in the 7.3 world.

Ken Received on Tue Aug 24 1999 - 08:27:35 CDT