Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Triggers on multiple similar tables

Triggers on multiple similar tables

From: <jshiruru_at_att.com>
Date: 1997/01/23
Message-ID: <854047898.14487@dejanews.com>#1/1

Hi all,

Thanks to all those who replied to my earllier queries. My next question is somewhat strange.
I have two tables 'table1' and 'table2' whose fields are exact mirror images of each other(don't ask me why). The data might be different, but the fields are same. A trigger must fire when any updates/insert are done on these tables. Is it possible to have only one trigger for these two tables. The Application Developer's guide says 'NO'. But is there a workaround solution where only one trigger is required for two similar tables ? I know I am asking for too much here. But it's just a shot.

Thanks a lot for any help

Jagdeep
jshiruru_at_att.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Thu Jan 23 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US