1 Reply Latest reply: Apr 6, 2010 11:32 AM by 728534 RSS

    Row Level Trigger Vs Statement Level Trigger

      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.