When use Before and After Trigger?

When use Before and After Trigger? Please any help for this one

Questions by Rakesh057   answers by Rakesh057

Showing Answers 1 - 2 of 2 Answers

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.

  Was this answer useful?  Yes


  • 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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions