Oracle PL SQL interview question Types of DML triggers | Order of trigger Execution if more than one

Просмотров 53 тыс.

% 731

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 ru-vid.com/show-UCBt6VrxAIb5jLh9HLDcdwtQ
Oracle Interview questions and Answers at ru-vid.com/group/PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm
Oracle 18C New features at ru-vid.com/group/PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW
Oracle 12C New features at ru-vid.com/group/PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx-
Oracle PLSQL records and collections at ru-vid.com/group/PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm

Наука

Опубликовано:

14 дек 2018

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 39

@aakashdubey9653 4 года назад

One of the best video I have seen ever for trigger. Thank you so much sir for your guidance

@SivaAcademy 4 года назад

@Aakash, thanks for your comments bro 🙏

@nisargpustakparyatan 2 года назад

Thanks. You are making it so easy to understand

@SivaAcademy 2 года назад

Glad to hear that!

@sujaa1000 4 года назад

Was very helpful Thank you

@SivaAcademy 4 года назад

Welcome 🙏 thank you

@sandeepdwivedi6065 2 года назад

@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.

@12345678966000 4 года назад

Hi Sir, Awesome explanation....waiting for more videos..👌👌👌

@SivaAcademy 4 года назад

🙏🙏, Sure 👍 👍, please stay tuned for more videos

@dreamheaven4661 3 года назад

bro is it possible to do video on nested trigger and cascading trigger

@parthparth8680 2 года назад

VERY GOOD VIDEO ON ORACLE TRIGGER

@SivaAcademy 2 года назад

Thank you

@tradersadda7297 11 месяцев назад

what is the difference between before and after trigger why do we need both....can you please explain with example

@arivarasane9382 Год назад

Hi sir need explain the how to use flowup in triggers

@aravindrajendran581 5 лет назад

Hi sir , Good Morning.. Your collections part is fine.. Thanks .. Please give videos on SQL tuning , interpreting explain plan in depth.. We are waiting...

@SivaAcademy 5 лет назад

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

@aravindrajendran581 5 лет назад

@@SivaAcademy Thank you sir

@manikandanp3128 3 года назад

Hi Sir, I am getting incorrect syntax near 'after' Please correct me

@4ashutosh 4 года назад

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.

@SivaAcademy 4 года назад

@Ashutosh, sure, will cover all the above trigger related question in upcoming interview questions, please stay tuned.

@vaniganapathi830 9 месяцев назад

Were your questions answered?

@user-jg9fd9ql3t 9 месяцев назад

@@vaniganapathi830 sivakacademy.blogspot.com/p/sql-plsql-interview-questions.html - Go here and serach trigger. I see almost all questions are answered by Siva.

@sivarajumandam8613 4 года назад

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

@riyazbabu8499 4 года назад

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?

@SivaAcademy 4 года назад

Exactly the same question i am posting tomorrow, you can check tomorrow morning

@malimukesh564 5 лет назад

hi..can anyone please tell me, i want to translate the language of whole record from english to telugu

@SivaAcademy 5 лет назад

Hi Mali, Is this for your understanding? or you want to publish somewere after translating the audio to telugu? Thanks, Siva

@Unel1993 2 года назад

Hi shiva gaaru, could you please make some videos on ETL for beginners. Thank you

@SivaAcademy 2 года назад

Sure, please stay tuned

@Unel1993 2 года назад

@@SivaAcademy thank you 🙏

@ssokkalingam7221 3 года назад

Pls share a video of bulk collect limit concept

@SivaAcademy 3 года назад

Sure, please stay tuned.

@jayashreejay2989 3 года назад

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?

@SivaAcademy 3 года назад

Will cover in next upcoming interview question series, please stay tuned.