| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Restricting FOR EACH ROW to newly inserted row
Hi,
If I have a trigger on a table that fires on INSERT is it possible to
restrict the trigger to only the newly inserted row? I want to add an
entry into a child (essentially a copy of the parent) table whenever a
new item gets inserted into the parent -- but I don't want the trigger
to fire on all existing rows in the parent table. Is there a more or
less standard way of maintaing two copies of one table in this manner?
Any help is greatly appreciated. Thanks.
Scott Received on Thu Nov 16 2000 - 22:39:57 CST
![]() |
![]() |