Re: Help with Mutating Table - Are there other solutions?

From: contrapositive <contrapositive_at_hotmail.com>
Date: Sat, 13 Dec 2003 15:22:48 -0500
Message-ID: <brfsei$2r2aa$1@ID-149469.news.uni-berlin.de>

"Frank" <fbortel_at_nescape.net> wrote in message news:brfqri$s4t$1_at_news1.tilbu1.nb.home.nl...

> Three triggers? 2; the original one (ear), and an after
> statement trigger. Where's the third?
> A package? Possibly - good for maintenance, considered good practice.
> --
> Regards, Frank van Bortel
>

Thanks Frank. Maybe you can elaborate. I'm not seeing how you can do this with just two triggers. The 3-and-1 approach I'm referring to is the classic workaround a la Tom Kyte (see http://asktom.oracle.com/~tkyte/Mutate/).

Thanks. Received on Sat Dec 13 2003 - 14:22:48 CST