Merge Statement in Oracle SQL with Example (UPDATE/DELETE or INSERT)

This video demonstrates how to write a Merge Statement in oracle sql, how it is useful in doing a conditional update or delete or both of them when the condition between the target table and source table is evaluated to true, and how we can insert the record into the target table when condition is evaluated to false. The video also shows the use of UPDATE, DELETE and INSERT with Merge, and also the various possible ways to use a Merge statement!!!

[Lpd]

Hi Kishan, Thanks for the clear cut information.
I came here to find whether we need to use both clauses or not. Thank god i found it as NO.

Note: Please check the voice and the video are not matching

[smrutiranjan]

Teaching style is superb carry on.thank u

[manasdash]

Hi I have a question.can u explain what happens in oracle engine when an update is occured inside a merge staement

[badalvlogs]

your fan voice is more than your voice lol🤣

[AniketPatil-yriw]

sir before uploading any video first check at your side and then publicized it.
voice is not clear . video presentation and voice are not in sync..

[surendrak]

Thanks for the video but the Voice is not good.

[badalvlogs]

need to work on basic thing like mike and audio is not at all clear

[hridayborah]

thoda slow kijiye ga, sounding fast and u in a total hurry

[pankajmakode]

GETTING THIS - ORA-30926: unable to get a stable set of rows in the source tables ERRO WHILE MERGING

[axwack]

Work on your presentation it’s not dry coherent or audible

[badalvlogs]

you need to eat something so that you will get some energy then you can speak louder.

[badalvlogs]

buy new mic if you are earning something or send me your phonepay no i will order new mic for you so thay it will get recorded properly
you keayboard is sounding more than you bro