Can we get a trigger of one table on another?
-
I have got four tables. When update happens in any of the four tables a trigger should be fired. i have written it for one table. is there any way to get this same trigger for all the other tables also? Or should i write different triggers for all the tables. I am having difficutly in enabling the trigger for other tables using the enable trigger command. dont know if that is possible. Please help. Thanks in advance. Lavanya:rose:
-
I have got four tables. When update happens in any of the four tables a trigger should be fired. i have written it for one table. is there any way to get this same trigger for all the other tables also? Or should i write different triggers for all the tables. I am having difficutly in enabling the trigger for other tables using the enable trigger command. dont know if that is possible. Please help. Thanks in advance. Lavanya:rose:
You should have different triggers for each table, mainly because each table will be structured differently, and I assume that the triggers will be different.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world." Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that." Deja View - the feeling that you've seen this post before.