Merge in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

Merge in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

Oracle 9i introduced merge statement. Merge is DML command which is used to transfer data from one table to another table when table structures are same.

Merge statement is also called as upset statement because in merge we use update, insert commands. Used in data warehousing applications. Whenever we are using merge statement then we must create table alias names names within merge command.

Oracle 10g onwards we can also use delete command along with update command in merge statement.

Syntax:

merge into target tablename
using source tablename
on (joining condition)
when matched then
update set target table column1=source table column1,....
when not matched then
insert (target table column names) values (souce table column names);

Please do check our daily posts, videos for beneficial informations, in case of any additional queries please do contact us, we are happy to assist you.

Please Do SUBSCRIBE our Youtube Channel and Support us :-
https://www.youtube.com/a4uofficial

If any difficulties regarding our posts, videos or other problem you can direct contact us:- allforyoucreators@gmail.com

If you found this post was helpful then please don't forget to SUBSCRIBE our channel.
Subscribe us for more such posts, videos and updates.. It's Free!!

For Businesses Inquiries :- allforyoucreators@gmail.com
_____________________________________________________________________________

Join Us on Social Media -
Like our Facebook Page :- https://www.facebook.com/a4u0fficial/

PLEASE SUBSCRIBE US FOR MORE POSTS, VIDEOS AND STAY TUNED..
CREATIVE, INFORMATIVE & BENEFICIAL CONTENTS TO BE FOUND ON OUR CHANNEL!!
BECAUSE WE KEEP UPLOADING VIDEOS ON YOUTUBE FOR YOU..
ALL WE NEED IS YOUR SUPPORT ❤

=▶ Thanks for your Love and Support ◀=

Copyright ©All For You Official

Post a Comment

0 Comments