Re: automatically execute triggers?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 21 Jan 2000 18:25:34 +0800
Message-ID: <3888341E.7A35@yahoo.com>

Peter Kellner wrote:
>
> Is there any way to get all triggers in a given table to execute?
> We added some trigger code that fixes certain bad data, and I'd like
> to have that executed for each row in a table. I'd like to be able to
> make a loop through all my tables to do the same thing.

If its an update trigger, you could issue

update table
set col = col

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Jan 21 2000 - 04:25:34 CST