Re: How to fire a trigger on insert into a view

Subject: How to fire a trigger on insert into a view RK re-arranged the electrons to say:

>Group :
 

>I was curious whether there is a way to fire a trigger which would do
>insert into the base table when I do a insert on a view which is a join
>of 2 tables containing all the not null fields.
 

>RK

Haven't done this, but, according to Oracle, 7.3 supports insert, update and delete on unambiguous join views. So, using 7.3, you can just insert into the view, with the actual data going into the base table(s).

Paul Received on Sun Apr 07 1996 - 00:00:00 CEST