Oracle PL SQL interview question Types of DML triggers | Order of trigger Execution if more than one
ฝัง
- เผยแพร่เมื่อ 5 ส.ค. 2024
- Oracle pl sql interview questions
1.What are the types of DML triggers?
2.What is the order of execution of trigger if there is more than one trigger exits?
Click here to subscribe to my youtube channel / @sivaacademy
Oracle Interview questions and Answers at • oracle interview quest...
Oracle 18C New features at • Oracle 18C New Feature
Oracle 12C New features at • Oracle 12C New Feature...
Oracle PLSQL records and collections at • oracle plsql records a... - วิทยาศาสตร์และเทคโนโลยี
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!
@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.
Was very helpful
Thank you
Welcome 🙏 thank you
bro is it possible to do video on nested trigger and cascading trigger
Hi Sir,
Awesome explanation....waiting for more videos..👌👌👌
🙏🙏, Sure 👍 👍, please stay tuned for more videos
VERY GOOD VIDEO ON ORACLE TRIGGER
Thank you
what is the difference between before and after trigger why do we need both....can you please explain with example
Hi sir need explain the how to use flowup in triggers
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 Sir,
I am getting incorrect syntax near 'after'
Please correct me
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
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
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.
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
Hi shiva gaaru, could you please make some videos on ETL for beginners. Thank you
Sure, please stay tuned
@@SivaAcademy thank you 🙏
Pls share a video of bulk collect limit concept
Sure, please stay tuned.
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
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