Re: Global Triggers?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 19 Mar 2001 23:37:55 +0100
Message-ID: <tbd2mbjvnjq3af@beta-news.demon.nl>

"JimWilson" <nospam_at_nope.com> wrote in message news:MPG.15201f353f1f006a98968c_at_news.bellatlantic.net...
> Hello,
> 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.
>
> Jim

There is not.
You could decide however
a) to write a trigger generator in pl/sql b) to use Designer 6i which will generate your triggers automatically.

Hth,
Sybrand Bakker, Oracle DBA Received on Mon Mar 19 2001 - 16:37:55 CST