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

--------------------------------------------------------------

--------------------------------------------------------------

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

--------------------------------------------------------------

[dhirajshinde]

Thanks for making the concept clear !! 👍

[gaddainaresh]

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

[avinashbethi]

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 ?

[mahadevgolabhanvi]

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

[kdausu]

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

[noorullabaig]

Super explanation sir. Thank you so much

[menaceasif]

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

[chandudevarapu]

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

[krishnaharshiniyallampalli]

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.

[KohinoorEntertainmentsDivit]

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

[SanjayKumar-yhfd]

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

[tummalanagarani]

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

[muralisethi]

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

[devavarapusrinivasurao]

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

[masalhemant]

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

[kuldeepgupta]

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.

[YOGESHKUMAR-ffor]

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.

[kunuturuaravindareddy]

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.

[shanawazali]

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 ?

[VPcaptures]

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