PL/SQL tutorial 17: Make synchronized backup copy of a table using DML Trigger

Learn how to make a synchronized backup copy of a table using DML Trigger in oracle database by Manish sharma RebellionRider
------------------------------------------------------------------------
►►►LINKS◄◄◄
Previous Tutorial
► Giveaway announcement

►Table Auditing using DML trigger

►Learn copy table with or without data using Create Table As

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

[shreeratan]

bro code is perfect and i'm in love with your explaination.you are G.O.A.T!!

[armanalirahul]

can you plz tell me why we use where expression? ( WHERE 1 = 2) in this query --> CREATE TABLE superheroes_backup AS SELECT * FROM superheroes WHERE 1=2;

[CidaLunacorteecostura]

I liked this video and your explanation. Thank you!

[thulasireddy]

What is the difference between before and after

[abdihakimmohamed]

Thank you Manish for the tutorial. Whenever I use the pseudo record :NEW or even :OLD I get an error I don't know why. I had to even copy the code from your blog but still throwing an error. I am using Oracle12c. There is a red line below the pseudo record. Help

[aviksengupta]

can you please provide me a query? I have inserted one row values in a backup table, create TABLE_BK as select * from TABLE where DOC_ID = ABC;
now I deleted DOC_ID = ABC from TABLE, now I need to insert all the values of row where DOC_ID = ABS from TABLW_BK to main TABLE.

[harshjain]

What does 1=2 means?? is 1 means table 1 and 2 means table 2???

[rahulkumarprasad]

Hey Manish .. I know you have a comment notification regarding this video .Please reply me the same.

[khyatiist]

Awesome explanation Manish. Thanks for sharing. Please tell me what does 1=2 in the where clause mean? Sorry if that's basic but I have never used it.

[sahilehsan]

I had observe some cases.
This trigger query is ok and will work absolutly with single column. But what about if I am having more than 50 columns in a table. How we can write update statement for that?
Can you share me script as well for the above query.

[krishnasingh-obob]

ORA-04079: invalid trigger specification give error all time

[ManojYadav-lcby]

i need to create a backup copy of same table in different database and that should be updated when primary table is getting updated. is this possible with this trigger?

[arungupta]

Nice video bro.. thanks for sharing your knowledge

[shikharchaudhary]

in oracle isql plus this is coming for same code , Warning: Trigger created with compilation errors . What to do ?

[anushat]

How to get a copy of table along with constraints and indexes

[rameshas]

How to achieve this in oracle form plsql trigger

[Faizyxyz]

Hi Manish Sir,
I just want to know in this query INSERT INTO superheroes_backup (SH_NAME) VALUES (:NEW.SH_NAME);
you have given superheroes_backup table name then after (SH_NAME) why so i am confused here why have you given this (SH_NAME)

[gulzarsiddique]

can we use multiple columns in this program for backup ???

[tarunsmdtp]

can we backup the data from one DB to another DB as well?

[bdub]

Hi Great videos. I do have a question,

Can you have multiple "SET column =:new.column WHERE column =:old.column;" in an ELSIF statement. I have created a movies table and if i wanted to update a certain column can this be done with "SET column =:new.column WHERE column =:old.column;" statement or is this something more advanced in some of your later tutorials?

Thanks
Bdub