HomeОбразованиеRelated VideosMore From: Manish Sharma

SQL tutorial 73: NVL2 SQL null function By Manish Sharma RebellionRider

187 ratings | 22107 views
Part 2: SQL Null Function NVL2 learn the concepts of NVL null function in this tutorial with examples and all the Interview concepts covered ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/nvl2-null-function Previous Tutorial ► NVL function https://youtu.be/aRoTR5Jn6K0 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (13)
Ameer CA (21 days ago)
Hi Manish, How to replace all null values in a table with 0 using oracle SQL ??
Hein Min (10 months ago)
Nice Video....
Shrihari shamji (1 year ago)
What do you think about this? Select NVL(DECODE(Commission_pct,NULL,'No value'),Commission_pct) from Hr.EMPLOYEES where salary > 13000;
Sri Giri (1 year ago)
Thank you Mannish your all video are interesting and helpful. Thank you for sharing you wonderful knowledge.
Prasenjit Saha (1 year ago)
All your videos are on steroids. What others would take 10-15 mins you take just 3 mins to explain . And after watching even a layman is bound to understand.
RUBÉN GIL (1 year ago)
you are INCREDIBLE thanks a lot from spain !!!
Abhishek Rayasam (2 years ago)
Got cleared with NVL, NVL2, COALESCE. What is NULL IF? Make a video on that to AVOID confusion. Thank You
Abdul Rehman (2 years ago)
Manish, can we use inner query in the place of value 1 inside the NVL2 function?
very clear!!! Thank you!
Gaurav Trivedi (3 years ago)
Thanks manish ,its really awesome to understand different b/t NVL & NVL2.
Sai Kumar (3 years ago)
select sal,comm,nvl2(comm,sal+comm,sal) net_sal from emp;
Himanshu Singh (3 years ago)
you know buddy, you are awesome. Always had confusion over NVL,NVL2 and Colase. Atlease clear on NVL and NVL2. Thanks
Manish Sharma (3 years ago)
+Himanshu Singh Thanks for the feedback it really means a lot to me. I am glad to hear that my videos helped you. Please Subscribe to my channel, give this video a thumbs up and Share it on your Social and help me in reaching out to more people and support free Education. Thanks

Would you like to comment?

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