Difference Row level trigger and Statement level trigger in Oracle PL SQL Interview Questions And Answers For Experienced & Freshers | Interview Preparation

Difference Row level trigger and Statement level trigger in Oracle PL SQL Interview Questions And Answers For Experienced & Freshers | Interview Preparation

Row level trigger :

1) For each row clause used
2) Allow to use when clause in row level trigger
3) Row level trigger has :new, :old qualifiers
4) In row level trigger, trigger body is executed for each and every row for a DML statement
5) Performance low as compared to statement level trigger

Statement level trigger :

1) For each row clause not used
2) Not allow to use when clause in statement level trigger
3) Statement level trigger does not have :new, :old qualifiers
4) In statement level trigger, trigger body executed only once per DML statement
5) Performance is high as compared to row level trigger.

Please do check our daily posts, videos for beneficial informations, in case of any additional queries please do contact us, we are happy to assist you.

Please Do SUBSCRIBE our Youtube Channel and Support us :-
https://www.youtube.com/a4uofficial

If any difficulties regarding our posts, videos or other problem you can direct contact us:- allforyoucreators@gmail.com

If you found this post was helpful then please don't forget to SUBSCRIBE our channel.
Subscribe us for more such posts, videos and updates.. It's Free!!

For Businesses Inquiries :- allforyoucreators@gmail.com
_____________________________________________________________________________

Join Us on Social Media -
Like our Facebook Page :- https://www.facebook.com/a4u0fficial/

PLEASE SUBSCRIBE US FOR MORE POSTS, VIDEOS AND STAY TUNED..
CREATIVE, INFORMATIVE & BENEFICIAL CONTENTS TO BE FOUND ON OUR CHANNEL!!
BECAUSE WE KEEP UPLOADING VIDEOS ON YOUTUBE FOR YOU..
ALL WE NEED IS YOUR SUPPORT ❤

=▶ Thanks for your Love and Support ◀=

Copyright ©All For You Official

Post a Comment

1 Comments