@siva Can we change order of firing triggers? and one more question Suppose we are having a table Employee and in the table a column is dept and values in dept column are 10,20,30 like this, So how to create trigger which only fire when we perform any manipulation in dept 20.
Nice video but I have 2 questions -- 1) How many triggers can be created on a single column of table? 2) What are the disadvantages of the triggers and how to solve the issues like mutating trigger issue? One more thing I wanted to ask is that please tell us about the attributes of the ROW level Trigger -- :OLD and :NEW with example.
@@vaniganapathi830 sivakacademy.blogspot.com/p/sql-plsql-interview-questions.html - Go here and serach trigger. I see almost all questions are answered by Siva.
Hi sir , Good Morning.. Your collections part is fine.. Thanks .. Please give videos on SQL tuning , interpreting explain plan in depth.. We are waiting...
Hi Aravind, Thanks for your comment. Ya, Few more pending items like nested table, and associative array left in collection, Once I complete the remaining , i will start with the performance tuning series. stay tuned. :-) Thanks, Siva
Excellent explanation Siva garu.. I have faced one Triggers question in interview , Could you please help me with that.. Same triggers event ( before insert statement level trigger) creating 2 triggers on same table. Which trigger will fire first?
Sir, can you answer these questions i got this in one of the interview 1) Can you call a procedure inside a trigger 2) Can you call a trigger inside a procedure 3) what is the difference between procedure and trigger?
Hi Siva sir your explanation is very very good sir,but I will ask one question can you please help me , I am currently working as PL/SQL developer last 5 years, which one is better forther learning course sir ,can you advise me if you don't mind sir
One of the best video I have seen ever for trigger. Thank you so much sir for your guidance
@Aakash, thanks for your comments bro 🙏
Thanks. You are making it so easy to understand
Glad to hear that!
bro is it possible to do video on nested trigger and cascading trigger
@siva Can we change order of firing triggers?
and one more question
Suppose we are having a table Employee and in the table a column is dept and values in dept column are 10,20,30 like this, So how to create trigger which only fire when we perform any manipulation in dept 20.
Nice video but I have 2 questions --
1) How many triggers can be created on a single column of table?
2) What are the disadvantages of the triggers and how to solve the issues like mutating trigger issue?
One more thing I wanted to ask is that please tell us about the attributes of the ROW level Trigger -- :OLD and :NEW with example.
@Ashutosh, sure, will cover all the above trigger related question in upcoming interview questions, please stay tuned.
Were your questions answered?
@@vaniganapathi830 sivakacademy.blogspot.com/p/sql-plsql-interview-questions.html - Go here and serach trigger. I see almost all questions are answered by Siva.
what is the difference between before and after trigger why do we need both....can you please explain with example
Hi sir , Good Morning..
Your collections part is fine..
Thanks ..
Please give videos on SQL tuning , interpreting explain plan in depth..
We are waiting...
Hi Aravind,
Thanks for your comment.
Ya, Few more pending items like nested table, and associative array left in collection, Once I complete the remaining , i will start with the performance tuning series. stay tuned. :-)
Thanks,
Siva
@@SivaAcademy Thank you sir
VERY GOOD VIDEO ON ORACLE TRIGGER
Thank you
Hi sir need explain the how to use flowup in triggers
Hi Sir,
Awesome explanation....waiting for more videos..👌👌👌
🙏🙏, Sure 👍 👍, please stay tuned for more videos
Hi shiva gaaru, could you please make some videos on ETL for beginners. Thank you
Sure, please stay tuned
@@SivaAcademy thank you 🙏
Excellent explanation Siva garu..
I have faced one Triggers question in interview , Could you please help me with that..
Same triggers event ( before insert statement level trigger) creating 2 triggers on same table. Which trigger will fire first?
Exactly the same question i am posting tomorrow, you can check tomorrow morning
Hi Sir,
I am getting incorrect syntax near 'after'
Please correct me
Sir, can you answer these questions i got this in one of the interview
1) Can you call a procedure inside a trigger
2) Can you call a trigger inside a procedure
3) what is the difference between procedure and trigger?
Will cover in next upcoming interview question series, please stay tuned.
Your videos are excellent. Can you please do for python Java mongodb
Thank you, sure, please stay tuned
Was very helpful
Thank you
Welcome 🙏 thank you
Pls share a video of bulk collect limit concept
Sure, please stay tuned.
Hi Siva sir your explanation is very very good sir,but I will ask one question can you please help me , I am currently working as PL/SQL developer last 5 years, which one is better forther learning course sir ,can you advise me if you don't mind sir
hi..can anyone please tell me, i want to translate the language of whole record from english to telugu
Hi Mali,
Is this for your understanding? or you want to publish somewere after translating the audio to telugu?
Thanks,
Siva
in an interview i was asked what is the advantage of compound trigger and an example of compound trigger?
@divya, the next video is on compound trigger only, please stay tuned.
@@SivaAcademy thank u sir. Waiting for video