Rollback a transaction what happen to trigger
I have a table EMP which has a trigger that will insert a row in DEPT whenever I insert a row in EMP, i also has another trigger on DEPT which will update table COUNTRY whenever i have row insert into DEPT.
When i have a insert transaction in EMP, it will cause insertion into DEPT and also update COUNTRY.
EMP -> DEPT -> COUNTRY
If i rollback transaction in EMP, will I also rollback the DEPT and COUNTRY?
thanks