Re: How to update through a joined view in 8i?

I appreciate your taking the time to respond, but this misses the point of my original question. The INSTEAD OF trigger was availiable before Oracle 8i. Starting in 8i, Oracle has claimed that you can insert, update, and delete records directly through a JOINED view - without using triggers - under certain conditions. The example they give for it, though, doesn't work. If you've seen anyone use this ability, I'd appreciate hearing how they did it.

"Chun-Yen" <agi_at_haa.com.tw> wrote in message news:8pi1tv$ieo$1_at_nnrp1.deja.com...
> In article <4Gyu5.1711$964.243228_at_paloalto-snr1.gtei.net>,
> "CA" <progplus_at_gte.net> wrote:
> > Anyone here successfully updated (or deleted or inserted) data
 through a
> > joined view in Oracle 8i? The online docs provide an example of how
 to do
> > this, and the example itself doesn't work. If anyone could provide a
 brief
> > example of how to make this work, I'd sure appreciate it.
> >
> You can using INSTEAD OF trigger.
> have a look at
> http://technet.oracle.com/doc/server.815/a68003/01_13dbt.htm
>
>
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Sep 11 2000 - 10:12:00 CDT