NVL and NVL2 Functions with real world example

[@Blissful_Echoes-f6t]

thank u sir for simple explanation. if possible plz provide Q and A for a Experienced person in SQL .

[@RahulJadhav-fe6ry]

very nice simplified i understood easily thanq sir

[@kunnudev7250]

Bhai great job please continue awesome videos

[@sadamalialimuhammad154]

Thank you sir

[@Visionpro33]

Thank you sir, very helpful

[@shahbazhussain1492]

Too good bro.....🙏🙏

[@vickypatekar9532]

Thank you so much sir Toooooooooo Good Explaination

[@TechShooterIN]

Thanks to you brother for support and comments

[@atkuriajaykumar3701]

Thankyou sir

[@mayurramteke8585]

in nvl2, if the first expression exists then the second expression will be shown and if the first expression does not exist then the third expression will be shown.

[@1.shivamchaudhary]

I have a requirement that i need to set parameter as text and for passing multiple values user can give multiple values by using comma...... And if user will not give any value it returns all the values.... E.g. where pha.segment1 IN (:Segment1) Here we can paas multiple values but not null........if i use nvl here it will give error bcoz IN clause not used with nvl

[@avinashjha7969]

Sir how to use in function with nvl function both together

[@mayurramteke8585]

if the first expression exists then it will be shown. and if the first expression does not exist then the second expression will be shown.

[@anilpatidar4179]

Thanks sir