Re: Question about triggers

> Do triggers start firing upon completion of the commit transaction?
>
> For example, if I have updated tables T1 and T2, and I have a trigger
> on T1 that depends on T2 transactions getting committed, do I need to
> make sure T2 gets commited first and then commit T1? Or could I simply
> commit once and the T1 trigger gets fired after both tables are
> commited?

In addition to the other answers, Oracle has row-level and statement-level triggers.

A row-level trigger will fire for, for example, each row deleted in table, while a statement-level trigger will fire for each delete statement executed for a table.

-- 
Martijn Tonies
Database Workbench - development tool for Oracle, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com