Difference row level and statement level triggers?

1 answer

Answer

1270391

2026-08-06 17:45

+ Follow

1) row level triggers can be identified by FOR EACH ROW is declared in the trigger declaration row level trigger is fired internally when any DML operation is occur in in any object like table it will fire for each row example: if any delete statement is occured for 30 records it will fire for 30 times.

2) Statement level triggers without declartion of FOR EACH ROW is statement level trigger is fired for every completion of statement example delete statement is occured for 3o records it will fire after the 3o records have been done

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.