Re: Creating Views

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 24 Aug 1999 18:06:00 +0800
Message-ID: <37C26E88.373E@yahoo.com>

Kenneth C Stahl wrote:
>
> 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

You can even do mods to joins in 7.3 - as long as they are key-preserved.
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Tue Aug 24 1999 - 05:06:00 CDT