Mrutyunjay Nayak

• Jul 1st, 2014

 

Before Trigger is used only when u want to restrict the invalid data entry in a table.After trigger is used when u perform the operation in one table that will effect on other table.

chaithanya

• Jul 1st, 2014

 

Before trigger is used while performing DML operations and whereas After Trigger is used for after performing DML operations

Real time Example for before trigger:

in banking systems:
they have created a trigger which fires automatically when u try to perform transactions after the Banking hours completed

But After trigger as i said it will fire after DML operations....
but the major difference is that we can not create an after trigger on View and updations is not possible for :new,:old parameter in After trigger

if u want example or more clarification check , check my blog joywithoracle.blogspot.in