Re: newbie trigger question

From: <chitnis_at_pspl.co.in>
Date: Thu, 03 Jun 1999 05:37:35 GMT
Message-ID: <7j54av$707$1@nnrp1.deja.com>

A before trigger is executed only once for each transaction. If you want it to be executed for every row that the source transaction affects, you should use the FOR EACH ROW clause.

Chitnis

In article <37556B0F.982CAFD5_at_cs.auc.dk>, Chen Li <erpeng_at_cs.auc.dk> wrote:
> Hi all:
>
> When I write a before insert trigger, in the trigger body, there is
> nothing but select
> something into a variable I defined in the trigger statement. Why is
> that when I use
> sql loader to insert some records, only half(every second) of them
are
> inserted.
> Thanks.
>
> Simon
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 03 1999 - 00:37:35 CDT