Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Triggers on multiple similar tables
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 UsenetReceived on Thu Jan 23 1997 - 00:00:00 CST
![]() |
![]() |