This discussion is archived
1 Reply Latest reply: Apr 6, 2010 9:32 AM by 728534 RSS

Row Level Trigger Vs Statement Level Trigger

ramarun Newbie
Currently Being Moderated
Hi All,

I am aware of row level and statement level triggers and how this works.

Still at times i feel when most of the requirements can be handled with row level trigger why statement level trigger was given by ORACLE. Whats the significant change/difference between row and statement level trigger. i.e There should be a reason why row level trigger was introduced specifically and similarly for statement level trigger.

Request all forum gurus to explain me on this with detail. Appreciate your time and patience.

Thanks in advance.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points