Re: Instead Of Triggers

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Wed, 27 Apr 2005 23:34:01 +1000
Message-ID: <426f94c3$0$26979$5a62ac22@per-qv1-newsreader-01.iinet.net.au>

Frederic apparently said,on my timestamp of 27/04/2005 1:08 AM:

> thought about an Instead Of Trigger, but I 've read somewhere sometimes
> that it is not a good idea to use this. Is it true ?

Like all triggers, there is an overhead. Not much more than running any other trigger that does DML. Not a good idea? I don't think so.

> Another question, I'm in 10g, ans I think that theses triggers used to
> be only in Enterprise Edition, is it always true ?

AFAIK, they are available everywhere?

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam

Received on Wed Apr 27 2005 - 08:34:01 CDT