Row level and statement level trigger

Ask a question
          

Row level and statement level trigger

<<Previous  Next>>

Oracle - Explain Row level and statement level trigger - Feb 23, 2010 at 11:00 PM by Rajmeet Ghai

Explain Row level and statement level trigger.

A trigger if specified FOR EACH ROW; it is fired for each of the table being affected by the triggering statement. For example if a trigger needs to be fired when rows of a table are deleted, it will be fired as many times the rows are deleted.
If FOR EACH ROW is not specified, it is application to a statement and the trigger is executed at a statement level.

Oracle - Explain Row level and statement level trigger - Feb 07, 2010 at 14:20 PM by Shuchi Gauri

Explain Row level and statement level trigger.

Row-level: - They get fired once for each row in a table affected by the statements.
Statement: - They get fired once for each triggering statement.

Oracle - Explain Row level and statement level trigger - April 10, 2009 at 11:00 AM

Explain Row level and statement level trigger.  

Row Level Trigger
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

Also read
Difference between post database commit & post-form commit

Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts.............

Disadvantages of trigger in oracle

Triggers can execute every time some field in database is updated. If a field is likely to be updated often.............

Oracle Triggers

What is trigger in oracle?, What are the types of triggers?, How the triggers are attached to the table?, What are triggering attributes?..............

What are cascading triggers?

When a statement in a trigger body causes another trigger to be fired, the triggers are said to be cascading.............

<<Previous  Next>>



Write your comment - Share Knowledge and Experience


 

 
Interview questions
 
Home | Login | About us | Sitemap | Contact us