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

SQL tutorial 74: SQL COALESCE Function In oracle Database Manish Sharma

371 ratings | 28483 views
Third tutorial in SQL Null Series. Coalesce Null function with example in oracle Database. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-coalesce Previous Tutorial ► NVL https://youtu.be/aRoTR5Jn6K0 ► NVL2 https://youtu.be/SCwc0HcS1-U ------------------------------------------------------------------------- ►►►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 -------------------------------------------------------------------------- ►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 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 (49)
Amrita Jaiswal (2 months ago)
Sir your explanation, confidence and the ease with which you clear basic concepts are amazing! Thank you so much for helping with technicalities :)
Manish Sharma (2 months ago)
Thank you for your kind words. Your appreciation means a lot to me. Positive feedbacks are always a great motivator. Thanks again.
Mustafa Farah (8 months ago)
thanks!!
Andalib Olee (10 months ago)
''Lionel Messi'' .. Bro how can i get only ''Lionel'' part using this function?
Shubham sharma (7 months ago)
ADD 'LIONEL' TO FIRST_NAME COLUMN AND DON'T ADD 'MESSI' TO SURNAME,i.e leave it empty...hence NULL get's assigned to it....place coalesce(first_name, surname) in select statement and you will get the result..
chandu a (11 months ago)
Very nice explanation..
shashanka vatticuti (1 year ago)
Awesome tutorials bud. Love it.
Mohammad Sleibi (1 year ago)
Nice explination Man ! .. go forward :)
Peaches Monroe (1 year ago)
Excellent! I now know Thor's home number! Thanks! 😜
Nikhil S (1 year ago)
great work
Sai Ram (1 year ago)
Hi, can we apply this coalesce function on the entire table
Pratik Bhoi (1 year ago)
Sir Can u share Oracle reports and forms tutorial links
Broken Channel (1 year ago)
great video thanks
Likitha gunda (1 year ago)
Fab!!Not even a single dislike..That is Manish!!!!
bharath kumar reddy (1 year ago)
Boss your simply superb..when ever I'm gng to intervies I will just go through all your videos which revises all concepts.... GREAT WORK BHAYYA
sushil bhosale (1 year ago)
plz add more videos on oracle on 11g as well as 12c as soon as possible
Nikhil Jain (1 year ago)
bro you didn't explain SQL replace () function. 😞
Hanuman Krishna (2 years ago)
excellent!
Santosh Aherkar (2 years ago)
I WANT TO KNOW ABOUT ALL THE SQL FUNCTION, SOME OF THEM ARE VERY COMPLICATED SUCH AS CLUSTER FUNCTIONS, XML FUNCTION GROUP FUNCTION(GROUP_ID, GROUPING), MAKE_REF, ORA_HASH, PATH, PERCENT_RANK, PERCENTILE_COUNT, PREDICTIONand many more.
Vicky Singh (2 years ago)
while opening the https://localhost:1158/em/ i m getting error like 503 Service Unavailable Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details. . kindly check and help asap
Priyank Mishra (2 years ago)
as videos are sort its very interesting
Priyank Mishra (2 years ago)
great work man
Software Developer (2 years ago)
great work..!!!!!!! please make some videos of Group By Functions and SubQuerries..
Hasnain Haider (2 years ago)
Great Sir! I like your videos
Shanmuga Sundaram (2 years ago)
Thanks a lot Manish. now starting your pl/sql
Abhishek Rayasam (2 years ago)
Sir. You're just awsum. Liked it and Understood very clearly. DOUBLE THUMBSUP.
Amrit Kar Sharma (2 years ago)
Awesome Sir
Lakshmi Thollikonda (2 years ago)
upto now I don't know coalesce function. But now I understood clearly with good example.Thank you sir.
Great Work........ Thank You............
Mona Luiza (2 years ago)
thanks! :)
great video!!!
Dianna Y (2 years ago)
Love your enthusiasm throughout the videos, keep up the great work! Looking forward to more "wassup internet" intros in your future videos
Manish Sharma (2 years ago)
Thank you for your appreciation, It further adds to my enthusiasm. It means a lot to me. Do keep watching, also help others in learning by sharing the videos on your social with your friends.
Lovepreet Kaur (2 years ago)
AwesoMe work !!!! keep the good work up !
Priya Ranjan Kumar (2 years ago)
nice video from this video I have clear the concept of coalesce function.
webprogramozás (3 years ago)
that's it. a bit simpler than reading through oracle manual :D
Moni Debnath (3 years ago)
Video is great but I want to see some more real life examples. Some may be in little complicated situations how we can apply this format.
movie mixer telugu (3 years ago)
hi brother, your sql video tutorials awesome, but you didn't upload sql sysonyms and some topics are missed, please upload that videos, thank you manish
Doğukan HAN (3 years ago)
Awesome , Thank you for all lessons :)
saeeda saeed (3 years ago)
great work
Ayoob manker (3 years ago)
Thanks,,, your great...
Abhi Abhang (3 years ago)
i see all the videos ...............gr8 job
VIVEK JAIN (3 years ago)
Videos was very helpful.
Grzegorz Bednarczyk (3 years ago)
Great tutorial as usual! Thanks for your great work!
vijaykumar dayalam (3 years ago)
Hi Manish, First off all i would like to say thanx to you for making this videos for us its very helpful. Is it possible to post PL/SLQ videos as well. if you have already pls give me the link or url where i can get. thnx, vijay
VIVEK JAIN (3 years ago)
very interesting video.... :)
Tumelo Keys (3 years ago)
You are the boss!i like your videos!now i can write my OCA!
Manish Sharma (3 years ago)
+Tumelo Keys Thanks for the appreciation, glad you enjoyed watching my Videos. All the best for your OCA. Enjoy
mayank s (3 years ago)
Good one thanks

Would you like to comment?

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