Re: Global Triggers?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 19 Mar 2001 21:34:36 -0800
Message-ID: <3AB6EBEC.3B322E58@exesolutions.com>

> 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 Mon Mar 19 2001 - 23:34:36 CST