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:-

My Vlog Channel link:-

Some Entertainment Video links:-

Contact Info :-

[ijihqpe]

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

[RahulJadhav-fery]

very nice simplified i understood easily thanq sir

[kunnudev]

Bhai great job please continue awesome videos

[vickypatekar]

Thank you so much sir Good Explaination

[mayurramteke]

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.

[.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
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 i use nvl here it will give error bcoz IN clause not used with nvl

[avinashjha]

Sir how to use in function with nvl function both together

[mayurramteke]

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.