Oracle PLSQL Tutorial 41- Difference Between Statement Level and Row Level Trigger in PLSQL #PL/SQL

In this Video, We are explaining about Difference Between Statement Level and Row Level Trigger in PLSQL with Example. Statement Level Trigger Statement level trigger executes once for each transaction. For Each Row clause is not used in Statement Level Trigger. Statement Level Trigger will be fired either row is affected or not. In Statement Level Trigger , we could not use OLD and NEW co-relation identifiers. In Statement Level Trigger, we could not use when clause. Statement level trigger performance is high as compared to Row Level Trigger. Row Level Trigger A row-level trigger executes once for every row. For Each Row clause is used in ROW LEVEL Trigger. Row Level Trigger will be fired only when row is affected. In Row Level Trigger, we could use OLD and NEW co-relation identifiers. In Row Level Trigger, we could use when clause. Row level trigger performance is low as compared to Statement Level Trigger. Some other Video related to PL SQL tutorial. Oracle PLSQL Tutorial 40- Trigger Part 3 (ROW Level Trigger) in Oracle PLSQL #plsql https://youtu.be/mgQNYulubYA Oracle PLSQL Tutorial 39- Trigger Part 2 (Statement Level Trigger) in Oracle PLSQL #plsql https://youtu.be/jxmHXsgw05A Oracle PLSQL Tutorial 38- Trigger Part 1 in Oracle PLSQL #plsql https://youtu.be/a93Bo7VtEdk Oracle PLSQL Tutorial 37- Package Part -2 with Example in PLSQL https://youtu.be/teL8qdwYW8w Oracle PLSQL Tutorial 36- Package Part -1 with Example in PLSQL https://youtu.be/Y7dMNSB59i4 Oracle PLSQL Tutorial 35- PRAGMA EXCEPTION_INIT with Example in PLSQL https://youtu.be/4MWu_AHMHbM Oracle PLSQL Tutorial 34- RAISE_APPLICATION_ERROR with Example in PLSQL https://youtu.be/qncI6ve1aR4 Oracle PLSQL Tutorial 33- User Defined Exception with Example in PLSQL https://youtu.be/iu47_kfszw4 Oracle PL/SQL Tutorial 32- Exception Handling with Example in PLSQL https://youtu.be/AokubrUjiXg Oracle PL/SQL Tutorial 31- Parameter Modes in Procedure(IN,OUT,INOUT) with Example https://youtu.be/-a6tqkz85pc Oracle PL/SQL Tutorial 30- Stored Procedure in PLSQL with Example https://youtu.be/6KoJPY5vA04 Oracle PL/SQL Tutorial 29- Function INOUT Parameter in PLSQL with Example https://youtu.be/k1HUR7-uzfU -------------------------------------------------------------------------------------------------------- Our Social Link:- Link (Blogger) : https://javainhand.com Link (Facebook Group ) https://www.facebook.com/groups/145218296146795/?ref=bookmarks Link (Facebook Page) https://www.facebook.com/javainhand2017/