Re: Global Triggers?

From: M Hashim <mhashim_ca_at_passport.ca>
Date: Tue, 20 Mar 2001 23:08:02 -0500
Message-ID: <3AB82921.466D2F0@passport.ca>

Have you tried setting up a view then update thru the view.

Also,
INSTEAD-OF triggers are available only if you have purchased the Oracle8i Enterprise Edition.
INSTEAD-OF triggers provide a transparent way of modifying views that cannot be modified directly through SQL DML statements (INSERT, UPDATE, and DELETE).

Sybrand Bakker wrote:

> "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 Tue Mar 20 2001 - 22:08:02 CST