Oracle interview Question : what is trigger in oracle

[@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!

[@SivaAcademy]

Its my pleasure :-)

[@vishalsaxena5081]

@@SivaAcademy can we use multiple trigger on one table

[@SivaAcademy]

Yes, you can, please look into this video kzbin.info/www/bejne/eaTZZIB7eqyDh6M

[@SivaAcademy]

Only either one of the update statement only will work, because you have mentioned in the if condition, based on the satisfying condition either of the one will work

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

[@SivaAcademy]

All the best

[@SAYEEDKHAN27]

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

[@SivaAcademy]

Welcome bro, its my pleasure

[@bezawitarage1686]

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

[@SivaAcademy]

Welcome

[@vickypatekar9532]

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

[@SivaAcademy]

Thanks for your comments bro 🙏

[@dba_wokezilla2176]

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

[@JyotiSharma-wb1vy]

Your explanation is very clear and concise!

[@SivaAcademy]

Thank you

[@bindubindu7222]

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

[@SivaAcademy]

🙏🙏Welcome

[@chenthi2004]

Concepts are very clearly explained. Thank you

[@SivaAcademy]

Welcome bro

[@manojkumarrajaka5204]

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

[@SivaAcademy]

Its my pleasure bro, thank you for your comments bro 💐💐💐

[@vivektarab16]

Start 0:21 - Types of Trigger 0:42 - What is Trigger 2:56 - Trigger Definition 3:42 - Types of Triggers 4:30 - DDL Trigger

[@pradipkrpandey6482]

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.

[@shauryasworld06]

Same confusion

[@KaushikGovindharajan]

Thank you sir. Great video.

[@sprangyabehera4227]

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

[@SivaAcademy]

Thank you, please look into this video for more details kzbin.info/www/bejne/innIimhvjdxliKs

[@martinsuresh5048]

very helpful information hatsoff sir

[@SivaAcademy]

Thanks Martin for your comment.

[@sudarsanrout5787]

Great Bro 👍

[@SivaAcademy]

Welcome bro

[@kunuturuaravindareddy5580]

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 .

[@SivaAcademy]

Covered in detail here, please look into this kzbin.info/www/bejne/innIimhvjdxliKs

[@divakardasannagari1615]

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

[@SivaAcademy]

Hi, DDL trigger will get fired in case of truncate, please look into this video kzbin.info/www/bejne/innIimhvjdxliKs

[@lokeshseenu5731]

You mentioned that there is DDL trigger, but in previous video Diff b/w Delete and truncate, you mentioned that Truncate cant used in Trigger.. Can you please clear this point.

[@vsr1727]

Thanks Siva for sharing info..

[@SivaAcademy]

Welcome 🙏

[@mayusdining26]

Gr8 video Helpful, thank you

[@SivaAcademy]

WELCOME 💐🙏

[@rajt5218]

very nice

[@SivaAcademy]

Thank you

[@srinivasreddy186]

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

[@prathameshkhot5717]

Thank you Siva. God bless you....

[@SivaAcademy]

Welcome bro 🙏

[@masalhemant4255]

Nice Explanation............

[@SivaAcademy]

Thank you

[@priyankachavan4823]

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 ?

[@SivaAcademy]

Thank you, please look into this video for more details kzbin.info/www/bejne/innIimhvjdxliKs

[@dineshganyarpawar5441]

Such a good observation.

[@sumantwankhede]

Siva Really nice bro...can't we create trigger on 'CREATE' DDL event?

[@SivaAcademy]

Yes we can, its DDL triggers, will post a video soon, please stay tuned

[@tejupansare4947]

@@SivaAcademy in first video u said when we use truncate trigger not fired then here how u mention truncate trigger

[@subasswain2287]

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

[@SivaAcademy]

@subas, thanks for your comments bro 🙏

[@subasswain2287]

most welcome sir..could you plz upload some video regarding join concept and difference between equijoin and natural join ..

[@SivaAcademy]

@Subas, sure, please stay tuned for videos on joins.

[@subasswain2287]

thank u sir...

[@sahinsahina8440]

Nice explanation , please say about oracle forms

[@surendharm2520]

As you said trigger will not fire when you do truncate. But in this videos you are saying trigger will get fired when doing a DDL statement. I am not able understand that points. Pls

[@SivaAcademy]

Please look into this video kzbin.info/www/bejne/innIimhvjdxliKs

[@padmapriya1262]

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

[@SivaAcademy]

Welcome, its covered in this video, please look into this, kzbin.info/www/bejne/hnbJeaivmJxssK8

[@padmapriya1262]

@@SivaAcademy thankyou sir let me check

[@tanujain4894]

Can we have commit rollback in triggers? If not can you please explain?

[@guruapps757]

Good explanation

[@SivaAcademy]

🙏🙏👍

[@sameerahmad7592]

Was this an Interview Question or simply the entire theory of Triggers...? Interview Questions are the one which you place up here and the person listening or watching your video totally gets amazed. Two of them related to a Trigger can b.. 1) How many(max) Triggers can be applied at any instance....? 2) How to commit any DML execution in Trigger...? can you place some more question related to it....?

[@SivaAcademy]

Welcome 🙏, first question is already posted as part of interview questions, I guess the last two videos in this series cover about the number of triggers that can be written on table, regarding second question I will explain in upcoming videos

[@sachinzawar3085]

Hi Sir, Can we let trigger fire if data is inserted into table but yet not committed ?

[@ratheeshg1896]

Truncate fires the Trigger?

[@suryaprakash7880]

Sir I have a dought statements, Tiggers these both are different can u please explain to me briefly sir

[@devanaidu9406]

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

[@SivaAcademy]

Thank you, please stay tuned for video on trigger vs constraint.

[@devanaidu9406]

@@SivaAcademy ok thank you sir

[@subhamdalai8477]

Dear sir, You taught us Truncate doesn't fires a trigger!

[@ankushgurav8967]

Thank you

[@SivaAcademy]

Welcome

[@srjjsr9488]

What is underline table?

[@manjutharak]

Why we can't use Commit command directly in Trigger bro

[@YuKi-ll4mg]

What are the disadvantages of triggers?

[@anniekuris572]

Truncate cannot have trigger right?

[@WorldEye88]

Thank you, very nice.

[@SivaAcademy]

Thank you so much :-)

[@battikalaanilkumar1429]

can you explain about trigger in queue

[@khapneakshay4307]

Sir what do mean by mutetating error?

[@sarikagawde9910]

In delete and truncate diff slide you mentioned that trigger will fired on delete and not on truncate..but we can fire trigger on truncate it via DDL trigger,then how we will answer to interviewer in this case

[@SivaAcademy]

Please look into this video for detailed answer kzbin.info/www/bejne/innIimhvjdxliKs

[@sarikagawde9910]

Thanks for detailed explanations

[@SivaAcademy]

Welcome

[@chandudevarapu1578]

Can you please explain how wll you do complex referential integrity through triggers instead of doing f-key p-key relationship. Which situation we prefer this trigger

[@SivaAcademy]

Sure please stay tuned

[@pulluriphani1185]

Hi sir I have a question In difference between delete and truncate video you told in case of delete statement on a table trigger will get fired and not incase of truncate and you shown with an example as well at that point of time it's clear and now in this video DDL trigger will invoke when we truncate a table and My concern is how it is possible that DDL triggers will fire. In first video there will be no trigger fires when truncate happens. Please clarify the doubt sir

[@SivaAcademy]

Replied to your mail

[@pulluriphani1185]

Thank you sir

[@arunkumarsajjan3728]

@@SivaAcademy sir send to me also. And explain about row level and statement level triggers are types of triggers are not?

[@barkat0098]

Sir. Same question from me also. Please share explanation. Any way you explained very well manner.... Thanks a lot..

[@SivaAcademy]

Thank you, please look into this video kzbin.info/www/bejne/innIimhvjdxliKs

[@garigasravyasree1631]

Sir I have a doudt. In diff b/w delete and truncate you have told that triggers not fired on truncate. Now in ddl trigger,we have truncate. Can we use trigger on truncate command or not?

[@SivaAcademy]

Please look into this video for clarification kzbin.info/www/bejne/innIimhvjdxliKs

[@JhonJhon-qw1kc]

Hello, In your previous video ‘delete vs truncate’ you said delete can invoke trigger when using on delete trigger but now I realised truncate is covered in DDL triggers. So please explain how it comes under difference between truncate and delete in your previous video. Thanks.

[@SivaAcademy]

Please look into this video, its already covered kzbin.info/www/bejne/innIimhvjdxliKs

[@jayatrisinha3829]

Hi Siva, One question: will the row level trigger defined on a table for update/delete operation on a table and if we are updating one row which does not exist in that table, will the row level trigger get fired?what will happen with statement level trigger, will that get fired in that case?

[@SivaAcademy]

Its already covered here, please look into this video kzbin.info/www/bejne/hnbJeaivmJxssK8

[@explorewithsdtelugu3886]

Hi,explanation is really great..But I need explanation with some code example

[@SivaAcademy]

@suresh, most of the videos I will be explaining with examples only, this video is just to tell the types of triggers from interview perspective... Will cover more examples in upcoming videos...... Thanks for your comments bro

[@abhishekbansal3419]

in video truncate vs delete you told trigger cant be used for truncate but in type of trigger under ddl trigger you wrote truncate ;

[@SivaAcademy]

You are right, delete and truncate has different behaviors trigger, covered in this video kzbin.info/www/bejne/innIimhvjdxliKs

[@manjutharak]

How many DML triggers we can create in one table

[@jagadishdogga4886]

12

[@bharathipandian45]

Can trigger be fired on truncate? You said it's not possible

[@SivaAcademy]

@Bharathi, DDL triggers will get fired on truncate whereas DML triggers won't get fired on truncate

[@SivaAcademy]

@Bahathi, watch this video for more details kzbin.info/www/bejne/innIimhvjdxliKs

[@bharathipandian45]

@@SivaAcademy thank let me check it out

[@SHIVAMKUMAR-qh8yo]

Brother , plz make unix videos,

[@naveenrajumeganathan8581]

Can you please how to debug trigger for large number of line code and also stored procedure, function and package. Is there any other best productive method to debug other than dbms_ouput.put_line?

[@SivaAcademy]

Sure, please stay tuned, will cover in upcoming videos

[@vishnuvardhanjadava4186]

Thanks for the great playlist. In Accenture's online test for PLSQL developer role, I encountered a question. Q: If a table has some triggers, happens to all of them when that table is deleted? Could you please help me with the answer??

[@SivaAcademy]

When we drop the table, all associated triggers will get dropped automatically

[@sivaperumalla5513]

sir, please do videos on functions and procedures. I have checked and didn't see a video on tjem.

[@SivaAcademy]

@siva, sure I will post soon, please stay tuned

[@g.sreekanthreddy1164]

Hi Siva nice work.. I want to know in which case function is used nd procedure is used. Was asked in many interviews

[@SivaAcademy]

Hi Sreejanth, Hopefully this would answer your question. kzbin.info?o=U&video_id=CkkIbsi_3cc Thanks, Siva

[@devapujagova423]

HI SIR, I HAVE ONE DOUNT ON DML TRIGGERS YOU ARE SAYING THAT GRANT AND REVOKE ARE DML TRIGGERS BUT BASICALLY THOUS ARE BELONGINGS TO DDL KNOW...

[@SivaAcademy]

Grant and revoke are DDL commands and not triggers

[@vivekgiri7262]

You mentioned in 1st video that Truncate will not fire the trigger then what is the point of creating a Truncate trigger?

[@SivaAcademy]

Yes, you are right, behaviour of trigger in delete and truncate is different, covered in this video, please look into this kzbin.info/www/bejne/innIimhvjdxliKs

[@vivekgiri7262]

@@SivaAcademy Thank you

[@alagarrajkalaivanan2644]

Nice explanation sir, could you please explain with a query wise any examples

[@SivaAcademy]

Sure will post, please stay tuned

[@tarakdas14]

Hi Siva, can we call procedure/function in a trigger and vice-versa

[@SivaAcademy]

Hi Tarak, Proc or function can be called from function, but not other way around

[@shaikrasheed2861]

Sir,,, could u please explain me about Triggers vs Constraints in Oracle ??

[@SivaAcademy]

This is one of the most asked question, let me try to post a video soon, kindly stay tuned

[@krishnaharshiniyallampalli1220]

Sir, Can we rollback a trigger?

[@mohammadzuber7175]

Hi Sir, I was asked in Interview Question , what is the difference between Constraints and Trigger.

[@SivaAcademy]

ideally we should not compare, but there are few similarities too, will cover in upcoming video

[@ajimsayyad7006]

Do you have soft copy notes to this vedio

[@rajendrakumarsethi3161]

Hi sir In one table how many number of trigger created, please explain in detail

[@SivaAcademy]

sure, will add it to upcoming video list, Please stay tuned

[@kkeerthana8959]

Hii sir.. Can you please post scenario based plsql questions

[@SivaAcademy]

Sure, please send me few questions, I will cover in upcoming videos

[@Barsha949]

Sir what's ur email id ??? I want to put some interview query ..in interview I couldn't solve 2plsql query .pls sir rply

[@SivaAcademy]

Please send me your questions to [e-mail]

[@jay.shah96]

How triggers affect the performance of a database?

[@SivaAcademy]

for eg, DML triggers get fired for every dml operation, suppose if you have a row level trigger, and you are updating lets say 100K rows, means, 100K times, the trigger will get fired..

[@vishalsaxena5081]

sir same all the videos u can upload in hindi

[@muralik479]

for few videos audio is low compared .

[@SivaAcademy]

Will get it corrected for upcoming videos, please stay tuned

[@sathya2650]

Clear explanation. But please increase your voice..

[@SivaAcademy]

Sure Sathya, Thanks for your comments.

[@Tipsypie1]

Why dont you use an Earphone and increase the volume to max. The voice is absolutely clear and at the right volume.

[@SivaAcademy]

Thanks for your comment Shubhra, In the latest videos, I have increased the volume.

[@12ravindrareddy]

Can we pass parameter in trigger ?

[@SivaAcademy]

No, but you can use packaged variables to access inside the trigger

[@triptinanhoriya8519]

Hi Siva, First of all..Many Thanks for such wonderful videos. Watching your video, I got hired as PL SQL developer in one of the MNCs. I have two questions realted to Triigers: 1) Is it possible to pass parameters inside Trigger? 2) Do select statement fires the Triggers? I believe that Answer is NO for both these questions but I want to confirm from you as you are the Master of this area. Thanks..

[@SivaAcademy]

Thank you, parameters cannot be passed, however we can send through global variables, select Statement won't fire trigger directly

[@1084tripti]

Thank you so much for your reply..

[@smb08387]

Hi when u got selected If possible can you share interview questions what they asked and how many years of experience you have

[@1084tripti]

@@smb08387 ○Difference between delete and truncate ○difference between primary key and unique key ○is roll back possible in truncate? ○create table emp as select * from employee where 1=2. Explain what this query will do? ○what is Sql loader and what does discard file contain. ○how to print sequence no other then rownum ○select 1 from dual union all select '1' from dual Will this query run? ○query for fetching and deleting duplicate . ○if cursor is already open then how can u identify it. ○how many rows have been updated in a table . How can you determine it. ○"Exception When Others " should be placed before any other exceptions or not. If not then why. ○how can u raise Exception ? ○how can u call any procedure for each records present in the table? ○what is pragma autonomous transaction. ○creating backup table using for all and bulk collect concept Few more scenario based questions

[@smb08387]

@@1084tripti Thanks for the questions

[@rama.get7868]

Voice is very low