Re: TRIGGERS ON MULTIPLE TABLES
From: Alvin W. Law <alaw_at_oracle.com>
Date: Wed, 3 Nov 1993 06:59:45 GMT
Message-ID: <ALAW.93Nov2225945_at_ap221sun.oracle.com>
> Is there a way to create a TRIGGER that acts on
> multiple tables ???
Date: Wed, 3 Nov 1993 06:59:45 GMT
Message-ID: <ALAW.93Nov2225945_at_ap221sun.oracle.com>
jcrupi_at_mystech.mystech.com (John Crupi) writes:
>
> Is there a way to create a TRIGGER that acts on
> multiple tables ???
You can create a stored procedure and reference it in multiple triggers. There are two advantages:
- your code will be more modular
- it actually runs faster, since stored procedures are stored in compiled form; triggers are not. -- Alvin W. Law .............................................. Oracle Corporation Senior Applications Engineer .................. 300 Oracle Parkway, Box 659306 Manufacturing Applications .......................... Redwood Shores, CA 94065 Email: alaw_at_oracle.com ........... Voice: 1.415.506.3390 . Fax: 1.415.506.7299