Re: Global Triggers?

From: Steve Bell <swayne.bell_at_sympatico.ca>
Date: Tue, 20 Mar 2001 16:00:36 GMT
Message-ID: <3AB77C9D.AC76A17F@sympatico.ca>

Hi,
The default of SYSDATE will work for new rows (inserts) but for updates you have to create the trigger on each table.

Hope this helps,
Steve

"Daniel A. Morgan" wrote:

> > I have a database with 27 tables. Each table has a common field
> > (update_date) that will contain the sysdate when the table is updated. I
> > can do a trigger for each of the 27 tables to do this or use a "global
> > trigger". My question is, is there such a thing as a global trigger?
> > something to write once and use on all tables. Thank you.
>
> As Sybrand says ... no there is not. But you could set SYSDATE as the
> default.
>
> Daniel A. Morgan
Received on Tue Mar 20 2001 - 10:00:36 CST