Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bogus table for "instead of" trigger
"Morten" <morten_at_kikobu.com> wrote in message
news:3C629E48.3090708_at_kikobu.com...
>
> 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
>
Instead of triggers are used to hide the complexity of database
implementation of Object types . For exmaple the XMLType is actually stored
in the the database as a set of related tables. Now if the user wants to
insert XML in the database he does not have to worry about structure, he can
will just insert using the view. The instead of trigger will actually have
the code inside to populate underlying tables.
hth
santysharma
Received on Thu Feb 07 2002 - 13:17:43 CST