Re: statement level trigger vs. row trigger

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 25 Apr 2002 09:05:35 +0100
Message-ID: <3cc7b8cf$0$236$ed9e5944@reading.news.pipex.net>

"Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message news:3CC6C9A7.5EDF4FC4_at_exesolutions.com...

> I would disagree with your explanation of statement versus row level
triggers. A
> statement level trigger fires one per transaction. You can do 1,000
inserts and
> the trigger will fire once for all 1,000 records. The row level trigger
will
> fire 1,000 times.

Another reason not to code committing every n records.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Thu Apr 25 2002 - 03:05:35 CDT