Re: logging table changes

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