Re: UPDATE or INSERT on a view ?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 22 Sep 2003 09:17:10 -0700
Message-ID: <1efdad5b.0309220817.205c4bf7@posting.google.com>

"Zixiong WANG" <z.wang_at_sysium.com> wrote in message news:<1064226325.855394_at_teheran.magic.fr>...
> Hi,
>
> Can I execute an UPDATE or an INSERT to a view ?
>
> Thanks,

dba_updateable_columns(or something like that. check dba_views) tells you which are updateable.

there are rulse. they are on otn.oracle.com dont remember all of them offhand.
you can use an 'instead of' trigger on your view to get around this.

so insert into view

triggers instead of trigger and inserts it somewhere else. Becareful with those. they are simple to write, but can be difficult to maintain since not everyone will realize its the instead of trigger that causes the problem. Received on Mon Sep 22 2003 - 11:17:10 CDT