Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Global Triggers?
"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
![]() |
![]() |