NVL and NVL2 Functions with real world example

#oracleshooter
#OracleShooter
#SQL
#and
#OR
Cover Topic:- This video explains the real concept of NVLand NVL2in sql with examples.
it very helpful to all the students and beginners as well. so keep going with oracle shooter.
SQL Tutorial for beginners,
Full Blogs Link:-
oracleshooter....
My Vlog Channel link:-
/ mylifemyface
Some Entertainment Video links:-
• Video
• Mylife Myface Vlog #22...
• Video
Contact Info :-
Instagram:- / mylifemyface
Facebook :- / mylifemyface11
Twitter :- / mylifemyface11
Blogger :- oracleshooter....
Email Id :- [e-mail]
Telegram Link:- t.me/joinchat/...
whatsapp Group :- chat.whatsapp....

[@kunnudev7250]

Bhai great job please continue awesome videos

[@RahulJadhav-fe6ry]

very nice simplified i understood easily thanq sir

[@snehallendave1]

😊

[@sadamalialimuhammad154]

Thank you sir

[@Visionpro33]

Thank you sir, very helpful

[@Blissful_Echoes-f6t]

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

[@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]

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.

[@avinashjha7969]

Sir how to use in function with nvl function both together

[@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

[@anilpatidar4179]

Thanks sir