Oracle PL SQL interview question | Oracle MERGE statement | oracle merge statement example

#SivaAcademy
Oracle PL SQL interview question | Oracle MERGE statement | oracle merge statement example
--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
/ sivaacademy
Home page: sivakacademy.blogspot.com/
Telegram Channel : t.me/SivaAcademy
--------------------------------------------------------------
Home page: sivakacademy.blogspot.com/
List of all oracle SQL/PLSQL Interview questions sivakacademy.blogspot.com/p/s...
List of all PLSQL Scenario based Interview Questions sivakacademy.blogspot.com/p/p...
List of all Subscriber questions and answers sivakacademy.blogspot.com/p/a...
--------------------------------------------------------------
Oracle Interview questions playlist • oracle interview quest...
Oracle 18C New features playlist • Oracle 18C New Feature
Oracle 12C New features playlist • Oracle 12C New Feature...
Oracle PLSQL records and collections playlist • oracle plsql records a...
--------------------------------------------------------------
My video courses at UDEMY www.udemy.com/user/2c29d781-3...
--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos
For any questions, please drop me a mail at [e-mail]
--------------------------------------------------------------

[@dattavaraprasadreddy2863]

thanks for doing these kind of videos sir...because of this channel only i got a job ,learned lot of concepts ,keep it up Sir...@@@thank you

[@SivaAcademy]

Its my pleasure, thanks for your comments, all the best 👍👍💐💐

[@kdausu90]

Very nice! I was using temp tables to accomplish this same task

[@mahadevgolabhanvi]

Superb explanation Siva, all videos are very informative and helpful 👍👍👌👌👌 thank you 🙏🏻

[@SivaAcademy]

Thank you bro 💐

[@avinashbethi1410]

Thank you so much for explaining. As a part of merge , can we delete record on target table if there is no record on source table with the matching emp.id ?

[@gaddainaresh7960]

So much of efforts putting specially on oracle sql plsql videos .. you are very great man..thank you so much siva garu

[@SivaAcademy]

Thank you very much 🙏🙏💐💐

[@dhirajshinde4752]

Thanks for making the concept clear !! 👍

[@SivaAcademy]

Welcome 🙏💐

[@tummalanagarani6423]

Very well explained. I am looking for ETL concepts and transformations explanation. Couldn't find in your videos. Are there any? Would be of great help if there are any

[@bharathibalakrishnan6521]

superb Siva! very good explanation..

[@SivaAcademy]

Thank you 🙏💐

[@hc6008]

Superb, excellebt vid..

[@SivaAcademy]

Thank you 💐

[@krishnaharshiniyallampalli1220]

Learnt lot of concepts sir. I really admire your teaching. Please do videos on performance tuning indetail more. And also on nested loop, hash, merge joins pls.

[@SivaAcademy]

Thank you bro, sure please stay tuned, will add to upcoming videos

[@menaceasif]

Very nice video sir, thank u so much... God bless you 🙏😊🙏

[@SivaAcademy]

My pleasure, thank you 💐🙏🙏🙏

[@chandudevarapu1578]

Hi sir... Your way of explanation is so good.. I have one question regarding sql tuning.. If one select query is running 4 to 5 hrs.. How can you find issues in that select stmnt without going to execution plan

[@masalhemant4255]

Nice explanation...Sir...👍👍👍❤️❤️

[@SivaAcademy]

Thank you bro 💐

[@dasubabuch1596]

Ur explaination was awesome.

[@SivaAcademy]

Thanks you 💐

[@rupeshdarwade7846]

Nice explanation, Thanks...

[@SivaAcademy]

Welcome

[@noorullabaig3756]

Super explanation sir. Thank you so much

[@SivaAcademy]

Welcome bro

[@KohinoorEntertainmentsDivit]

You are doing a great job. Do you conduct any online classes ? Will be glad to join it.

[@kiranshahane1095]

Sir you are simply great we have 👍🙏

[@SivaAcademy]

Thank you 🙏🙏🙏💐💐💐

[@SanjayKumar-yh8fd]

this vedio help me to learn the marge statement ,so thanks for the same

[@SivaAcademy]

Welcome bro 💐

[@debadattabeura6403]

Nice explaination sir

[@SivaAcademy]

Thank you 💐

[@rk-ej9ep]

Thank you soo mich sir....

[@SivaAcademy]

Welcome bro

[@saratchand4275]

good explained

[@SivaAcademy]

Thank you

[@parthparth8680]

Good....!

[@SivaAcademy]

Thanks

[@dreamheaven4661]

Thank u shiva

[@SivaAcademy]

Welcome bro 💐

[@kunuturuaravindareddy5580]

Hello Siva,it was good video.i have a doubt and it was question too for me in an interview ,how general insert is different from merge what is the difference between them when to use what ,we can generally use insert into ,though it comes with three functionalities in one statement how it differs from previously existing insert,update.

[@shanawazali6161]

Both the table have all Column name same it's necessary condition ?or if I have only one Column name same both the table then also I will be apply merge statement ?

[@AjithKumar-vk1fw]

❤

[@mrarpitmore6189]

Super

[@SivaAcademy]

Thank you

[@devavarapusrinivasurao2229]

Hi sir your videos are more informative.if it is possible please upload performance tuning videos tq sir

[@SivaAcademy]

Sure please stay tuned

[@pra463]

hi Sir facing Error "ORA-30926: unable to get a stable set of rows in the source tables" while merging the data of 2 tables having same structure...

[@srarts6990]

Hi Sir, I'm having one issue with merge statement, i wrote a merge state ment like below Merge into trgt_table t1 Using src_table t2 On (t1.id=t2.id) When matched then Update set t1.name=t2.name; But in my scenario there are multiple duplicate values are there in t1.id and t2.id columns because those are the referenced columns from another table. When i execute this script I'm getting error "Ora-30926 unable to get a stable set of rows in the source table" Can you please help me out on this query

[@YOGESHKUMAR-ff8or]

thanks for ur valuable help to improve ourselves. I have a question that how to create a table using a mask means I want to insert a table value with the mask. ie means want an output like 4 digits first/last pad from the account number.

[@SivaAcademy]

Give me sample input and expected output please

[@muralisethi]

Thanks siva for detailed explanation. Can we update more than one row?

[@SivaAcademy]

Yes Murali, you can, records that matches the join condition

[@gajendras7528]

What combinations can I use in merge statment?

[@masalhemant4255]

Sir plz upload vedio forLIMIT clause and how to handle bulk exception

[@SivaAcademy]

Sure, please stay tuned, next video in plsql performance tuning series is about handling exception in bulk collection, please stay tuned

[@masalhemant4255]

Thank you...

[@hemanthraj6054]

will u explain same merge with using pl sql code???

[@rammurthybhukya9069]

Can we insert records in 3rd table instead of Target table using Merge Statement with clause( When Not matched). Please advise.

[@SivaAcademy]

I dont think to

[@VPcaptures]

Is there any way to maintain the sort order in the MERGE INSERT operation?

[@SivaAcademy]

Can you please give me sample data and expected output

[@dhanrajshunkalwar7098]

How can we achieve SCD 1, 2 using plsql ?

[@kuldeepgupta8526]

hii Siva i need below ans with explanation If same kind of logic we put in function as well as procedure then which one will be faster.

[@SivaAcademy]

I dont think there will be much difference in execution

[@KISHOREKUMAR-yv2sd]

@@SivaAcademy bro can we have merge statement in procedures without using execute immediate.

[@SivaAcademy]

Yes bro, you can have merge statement like any other dml statement inside procedure

[@siprabehera4680]

Can we write join query in using clause ?can we merge more than 2 tables.like joining of two table will update in target table.how to write?

[@SivaAcademy]

Yes, you can, use the subquery instead of source table, however the target table should be only one table

[@sindhupinky4959]

Sir Can you please post some videos on Unix interview Question and answers

[@SivaAcademy]

Sure, I will start, please send me few questions you faced in interviews

[@hanumanthu1246]

if update record only have the resigned flag= Y means ?

[@SivaAcademy]

Expectation is , Those records that marked as Y , should be removed from target table

[@hanumanthu1246]

@@SivaAcademy Thanks

[@pawansonole9127]

Sir i have question Ipl table having team name and player name Mumbai rohit Mumbai pollard Mumbai boult Delhi dhawan Delhi rabada Result should be Mumbai delhi Rohit dhawan Pollard rabada Boult null Note : not using pivot function Answer here itself thanks

[@subhashisoracle3944]

don't view only keep like and subscribe

[@Satheesh9491]

Hi Siva Garu, How to get Second Highest Average salary , Department wise ? Deptno Avg(Sal) 10 1566 20 2175 ---> I need to display this department(Second highest average salary ) 30 2916 Can you please share sql query for above question ?

[@SivaAcademy]

Sure bro, will cover in upcoming video please stay tuned

[@Satheesh9491]

​@@SivaAcademy Can you share the video link

[@SivaAcademy]

I am yet to post, will try to post in couple of weeks, please stay tuned