Re: Triggers on Oracle7 - newbie

From: Keith <keith.wilby_at_AwayWithYerCrap.com>
Date: 22 Mar 2005 11:43:06 GMT
Message-ID: <Xns962177DD1B77Fkeithwilby@10.15.188.42>

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

>> I did wonder about "FOR EACH ROW" but wouldn't that update all rows?
>> Remember I'm a clueless newbie!
>>
>> Thanks for your help.
>> Keith.

>
> The clause causes the trigger to fire for each row that the DML
> statement affects. You can use the WHEN clause, or logic in your
> trigger, to determine if a certain row that has been inserted, updated,
> or deleted should be processed by the trigger. Rows that are not
> affected the the DML statement are never processed by a row trigger.
>
> This behavior is described in the SQL Reference manual under the CREAT
> E TRIGGER statement.

Excellent, many thanks for your help Mark.

Regards,
Keith. Received on Tue Mar 22 2005 - 05:43:06 CST