HomeНаука и техникаRelated VideosMore From: Subhroneel Ganguly

Optimize Code with Merge Statement in Oracle PLSQL.

5 ratings | 1031 views
Merge Statement in PLSQL not only optimize you code, it also make you code looks good and readable, save you from using a long and redundant code like using cursor loop, plsql collection object, all done with a few line of statement.
Html code for embedding videos on your blog
Text Comments (4)
Satish N (11 days ago)
This example helped in my client interview. Thank you.
vayunandu (2 years ago)
I can see your good efforts trying to explain merge(for instance any topic), but one suggestion.. you should start with a simplest example that you can possibly think of and further you may explain it with a complex example.. To be honest, I just literally stopped watching as soon as you started writing that complex query..! Hope you don't mind me giving feedback.
vayunandu (2 years ago)
No worries. Thanks for taking my comments positively (only few people do that). :) :) Happy teaching!
Subhroneel Ganguly (2 years ago)
Not at all... thanks for you feedback, actually this is my fault, I have been a little lazy for creating new scenario, rather find easy using an existing scenario, thats where the problem arised. Sorry for the inconvenience.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.