Re: Global Triggers?

That's what I was afraid of (27 triggers). Oh well, thank you very much all for your help any way.

Jim

In article <3AB77C9D.AC76A17F_at_sympatico.ca>, swayne.bell_at_sympatico.ca says...
> 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 - 11:58:01 CST