Oracle PL SQL interview question | What is Mutating Trigger

[ujjwalgiri]

A BEFORE INSERT trigger will not cause a mutating table error as long as the triggering INSERT statement is a single row insert (INSERT-VALUES).

[AparnaBL]

You are a good teacher. Your videos are crisp and clear with good presentation and your concept articulation is par ahead than most of the teachers on YouTube

[amanigrandhi]

Thanks Siva. I have learnt so many new concepts from your videos. You are doing a great job....

[SudhirBhajnawale]

Thanks a lot Siva for crystal clear explanation. One of Best Playlist for PL SQL Developers

[randomchitrakatha]

Thank you sir....ur way of explanation is too good....i learned everything in plsql from you only

[dattavaraprasadreddy]

doing a great job bro.. i learned lot of new concepts from u thanks a lot bro keep uploading new videos

[Parvej]

Really like all your videos, great explanation!!!

[dheemathimadhu]

Really very good explanation. Thankyou so much.

[sujaa]

Thank you Siva, the tutorial was very helpful
Sujaa

[SanjayKumar-yhfd]

Yes Sir, it is clear to me now, so lot of thanks, i have subscribe your channel sir, I joined this today,
way of teaching is very fantastic, so thanks again

[zaifikhan]

Thanks for all this informative videos

[riskassure]

Great video! Thank you. How do you modify the trigger so you cannot update CEO's salary to be below the second highest salary in the emp_t table?

[vikrantmukkawar]

Nice explanation I have one doubt why mutating error will come only in row level trigger not in statement level trigger ?

[TestingFever]

YOU ARE SO GOOD IN EXPLANING. THANKS!! CAN YOU DO A SHORT ONE ON Partition Pruning

[satishbhusal]

Great explanation. But from what I have read Statement level triggers can also cause mutation error when the ON DELETE CASCADE clause has been used. But I have seen this in 11g. I haven't worked with 12c or above versions. Can You please confirm?

[Krishna-hmdr]

How it's making restriction not to update on emp_t table If sal greater than 1lakh because trigger has if-else condition on log table only. Please clarify.

[shrk]

Hello from Russia. I just have known a new word "lakh")) thank you. Tell me please, Why do we need a second condition in where clause in select statement (about deptno)?

[shashank]

Nice explanation bro, pls make a video on cascading trigger, pipeline function, and explain plan etc.

[sujaa]

Thank you experienced developers will learn a lot from you.
Can you please make a video on how to debug a collection used in stored procedures.
Regards,
Sujaa

[ravindra]

Please make a vedio on performance tunning