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

From: Chun-Yen <agi_at_haa.com.tw>
Date: Mon, 11 Sep 2000 07:34:22 GMT
Message-ID: <8pi1tv$ieo$1@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 - 02:34:22 CDT