Re: Bogus table for "instead of" trigger

I can not make sense of your question. If you want to put a trigger on the table put a trigger on the table. It just won't be an "instead of" trigger.

Daniel Morgan

Morten wrote:

> Hi. From the documentation I can see that "instead of" triggers
> only can be placed on views. So I need to:
>
> create table bogus_table (id number);
> create view bogus_view as select id from bogus_table;
>
> create trigger bogus_trigger
> instead of insert into bogus_view
> .
> .
>
> Is this the correct way? Seems strange. What's the reasoning
> for not being able to make an "instead of" trigger directly
> on the table?
>
> Morten
Received on Thu Feb 07 2002 - 14:20:31 CST