Re: Question on Insert Trigger

From: Doug Miller <>
Date: Mon, 10 Mar 2008 15:10:55 GMT
Message-ID: <PjbBj.12679$>

In article <>, wrote:
>I am using on HP UNIX 11i.
>I have a third party application where I do not have access to code.
>When rows are inserted in a table, I do not want certain rows to be
>inserted . Rest of the rows should be inserted. Is it is possible to
>do this using a trigger.
>I wrote a trigger like following. This trigger is for illustrative
>purposes; conditions for filtering are more complex.
>create or replace trigger emp_aftins
>after INSERT ON employee

Perhaps I'm missing something that should be obvious... but why would you want to trigger *after* the insert? Don't you really want to trigger *before* insert, and insert only data that satisfies your criteria? Received on Mon Mar 10 2008 - 10:10:55 CDT

Original text of this message