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

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◄◄◄
Previous Tutorial
-------------------------------------------------------------------------
►►►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

--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
--------------------------------------------------------------------------

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

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

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[gauravtrivedi]

Thanks manish, its really awesome to understand different b/t NVL & NVL2.

[sriK]

Thank you Mannish your all video are interesting and helpful. Thank you for sharing you wonderful knowledge.

[rubengil]

you are INCREDIBLE thanks a lot from spain !!!

[SaiKumar-dmjb]

select sal, comm, nvl2(comm, sal+comm, sal) net_sal from emp;

[abdulabu]

Manish, can we use inner query in the place of value 1 inside the NVL2 function?

[himanshukp]

you know buddy, you are awesome. Always had confusion over NVL, NVL2 and Colase. Atlease clear on NVL and NVL2. Thanks

[ameerca]

Hi Manish, How to replace all null values in a table with 0 using oracle SQL ??

[abhishekrayasam]

Got cleared with NVL, NVL2, COALESCE. What is NULL IF? Make a video on that to AVOID confusion. Thank You

[prasenjitsaha]

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.

[maredinaveenkumar]

select first_name, last_name, NVL2(commission_pct, commission_pct, 'NA') from employees
where salary > 13000;
Error: Invalid Number
Please explain this

[MyShrihari]

What do you think about this?
Select NVL(DECODE(Commission_pct, NULL, 'No value'), Commission_pct) from Hr.EMPLOYEES where salary > 13000;