Rob Richardson wrote:
>
> But how is that significantly better than an update trigger that
> includes:
>
> If old.value <> new.value then
> do something
> End if
>
> RobR
>
>
It's better because the new version will not fire unless the "WHEN"
condition is satisfied, which means that you will save a few trigger
invocations, which should improve the performance. The present method
would fire every time, and check for the values.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions