Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
RE: Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
RE: Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
No we cannot generate trigger for two tables. If we want to fire the trigger for two table we can use nested trigger.
A trigger invoking another trigger is called as nested trigger.
RE: Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
Usha G your code is right but it only for first (SampleMainTable) table and execute whn you insert a record in the SampleMainTable tabe so its only for SampleMainTable table