Re: Question on Insert Trigger

In article <0d2f2afa-9bfc-4400-91a7-0e68f984ffad_at_p73g2000hsd.googlegroups.com>, zigzagdna_at_yahoo.com wrote:
>I am using 10.2.0.3 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