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

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?

[aakashdubey]

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

[nisargpustakparyatan]

Thanks. You are making it so easy to understand

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

[ashutosh]

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.

[aravindrajendran]

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

[dreamheaven]

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

[sandeepdwivedi]

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

[tradersadda]

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

[riyazbabu]

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?

[arivarasane]

Hi sir need explain the how to use flowup in triggers

[jayashreejay]

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?

[Unel]

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

[sivarajumandam]

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

[ssokkalingam]

Pls share a video of bulk collect limit concept

[divyadondapati]

in an interview i was asked what is the advantage of compound trigger and an example of compound trigger?

[manikandanp]

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

[malimukesh]

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