id="when-to-use-triggers">When to Use Triggers</h3>
<ul>
<li>Triggers can be used to enforce constraints that cannot be enforced in other ways
<ul>
<li>if assertions are not supported, then similar functionality can be achieved with triggers</li>
<li>but triggers are more powerful than assertions</li>
</ul></li>
<li>Triggers can be used for logging
<ul>
<li>if you want (or need) to keep change logs, then triggers can help</li>
<li>normally, when inserts, updates and deletes are executed on the DB, no traces