PL/SQL tutorial 15: DML Trigger With Before Insert, Update and Delete DML Examples

PL/SQL Tutorial 15 explaining DML Trigger with examples such as Before Insert, Update and Delete in Detail.

------------------------------------------------------------------------
►►►LINKS◄◄◄
Previous Tutorial
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.

-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

You can also Email me at
for E-mail address please check About section

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[krupashekhar]

Sir without you I don’t know how I would survive. You made my career. A million thanks would not be enough for you.

[ravithakor]

you explain each keyword of every topic with easy explaination
i cant thank you enough

[mastercvv]

Its a good video about the basic information about triggers, how to create and work with them. Thank you Mr. Manish Sharma for providing this good video.

[anithas]

Thank u Soo much Manish Sir. Your Tutorials are Very useful to me.

[imaginativeanu]

I have questions regarding trigger working parts, can you explain " select user into v_user from dual " this seems a bit confusing as why we are using dual table as the trigger is working for superheroes table, I might taking it wrong so can you explain it

[temitopeelizabethsorinola]

Thanks indeed Manish. You made pl/sql so easy for me.

[durgaprasadg]

Hi manish you explained very well.This is the way to understand the easy way.Thank you so much.

[aakashdubey]

Fantastic Manish, crystal clear explanation dear, I am fan of your teaching. keep rocking, thanks a lot

[f_affan]

Great learned a lot and still learning.Tq bro...doing a great job...keep it up

[shaheenshaikh]

Sir I'm getting error for this syntax of create or replace trigger bi_shero before insert on superhero for each row enable I'm getting invalid trigger syntax whats wrong

[_pinguso_]

amazing channel man, you are helping a lot of people, god bless you

[himanshumittal]

After removing the enable keyword it is working fine.Thanks :)

[l.salevi]

This is helping me so much right now! Thank you!

[rajeginger]

Hi Manish,
Thank you so much for creating such wonderful videos.It's helping people like me a lot. I have a request. could you please make video on indexes and pseudo columns

[PRUDVIESWARREDDYKOMATLA]

Thanks man these videos are Helpful for the learners.

[anngrahdhar]

Can you explain me that what is in the given line?
I did not understand where the word dual came from
SELECT user INTO v_user FROM dual;

[niki]

Hi Manish,
Thank you for your amazing tutorials, really helping a lot.
At my end, Triggers are compiled successfully but on Updating or Inserting Triggers are not working. Is anything additional to be done here???

[pravinmahindrakar]

You are making the life easy bro, cheers!😊

[saurabhchaurasiya]

Can anyone tell me why he is writing query select USER into v-user from dual, I mean I know the query but is this std. form or do we need to create a table named dual

[darshanamalviya]

hi manish, i got this error plz help me to come out "Do not create triggers on objects owned by SYS"