Oracle interview Question : what is trigger in oracle

Oracle interview Question : what is trigger in oracle

Description:

A Trigger is a special PLSQL code, that will be automatically invoked when a specific event occurs in the database.

The even can be DML event, DDL event or SYSTEM event.

What are the types of triggers?

DML Trigger - This trigger will get fired for DML events like INSERT,UPDATE and DELETE
DDL trigger - This trigger will get fired for DDL events like CREATE, ALTER, DROP, TRUNCATE etc.,
System trigger - This trigger will get fired for system events like LOGON, LOGOFF, STARTUP, SHUTDOWN etc
Instead of trigger - This trigger is created on view to redirect the DML operations to undelying base tables
compound trigger - This is a single trigger having blocks for all the DML timing events.

[MalluMusicVibes]

Thank you siva.After watching the whole series of plsql videos, I was able to brush up all the topics for my interviews. I even got job offers!

[akshardrashti]

Thank you Sivaji. After 7 years of break I am going to search job again. Your videos are helping me in brushing everything. So nicely explained.

[SAYEEDKHAN]

Explanation is in very simple and understandable language, without any technical complexity. Thank you.

[bezawitarage]

been struggling to understand what triggers are. now its clear thanks much keep going

[vickypatekar]

Thanks for sharing Siva Sir... Cleared all Concepts of Triggers 🙏

[dba_wokezilla]

Thank You for sharing the knowledge. I am also learning how to crack the interview in my channel.

[chenthi]

Concepts are very clearly explained. Thank you

[bindubindu]

This is very useful video for students and I very satisfied with your class sir. Thank you so much sir

[JyotiSharma-wbvy]

Your explanation is very clear and concise!

[manojkumarrajaka]

600th like..Bro ur doing great work..thank u and love u bro..

[sprangyabehera]

I really appreciate your video .I always watch your all videos but in first video, you said that in case of truncate, trigger dnt fire .But in this video you are saying about DDL trigger

[divakardasannagari]

Hi Siva, you explained indifference between delete and truncate video, in case of truncate triggers won't fire.

[pradipkrpandey]

Hi Siva Sir,
Thanks for your effort and hardwork for making wonderful videos.

I have an doubt in 1st vdo you telling that no trigger will fire for truncate but in this vdo you are telling that trigger can fire for truncate. So it's creating for confusion me.

[padmapriya]

Hi sir very well explaination learning lots from ur videos
Can u please explain these questions
1.What is trigger firing order on different type and timing
2.What is trigger firing order in same type and timing

[vivektarab]

Start

0:21 - Types of Trigger

0:42 - What is Trigger

2:56 - Trigger Definition

3:42 - Types of Triggers

4:30 - DDL Trigger

[kunuturuaravindareddy]

you said when explaining differences between delete and truncate truncate cannot be used with triggers and ur including that in ddl triggers just a observation .

[subasswain]

really all these video's are very helpful ..thank u so much sir.

[devanaidu]

Hi Sir your way of explanation is very welldone thank you for sharing your knowledge us keep sharing more videos sir and please make a videos dif between triggers and constraints

[srinivasreddy]

Hii shiva, could plz make videos on different purposes of triggers as u explained this video finally.. by simple examples and thank you so much fr such excellent info on triggers..

[priyankachavan]

Hi Sivaji, Thank you for the awesome work u are doing and explanations are quite easy to understand. I have a question here. In Delete vs Truncate you told like when we truncate a table, triggers will not get fired but here in DDL trigger you have listed truncate command. Could you please confirm its any different functionality or any different circumstances for truncate command ?