Re: Triggers on multiple similar tables

jshiruru_at_att.com wrote:
>
> 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.

  You need declare a trigger for each table. However, you can call same stored procedure in the trigger body of these triggers.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841