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

SQL tutorial 51: DECODE function in Oracle Database By Manish Sharma (RebellionRider)

306 ratings | 33155 views
SQL Tutorial 51 Decode function in Oracle Database. ● What Is DECODE() ● DECODE ( ) vs CASE ● Syntax of DECODE() ● Query 1. String Matching using DECODE() ● Query 2. DECODE() comparing values form the COLUMN of the table Celebrating 1000 subscribers. Thanks a lot guys for all your love and support. ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the first one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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 (11)
Harsh Parte (4 months ago)
Manish I have a query...In the first column i have some IDs..I want to compare 1 id with 2nd...if they are equal then return a column value else return another column value...how do I do it?...it's basically if a2=a1 then u2 else x2 in excel language
GavTutorials101 (5 months ago)
Thanks a lot sir!
vamshi sai (1 year ago)
Thanks Manish .....
Likitha gunda (1 year ago)
Awesome...The great thing about U is to make short tutorials still concept is Crystal clear..!!Thanks a ton!!
Ramesh G (1 year ago)
Hi Manish,Thanks for your time for oracle tutorial.I could not find date related funactions (to_date,to_char and to_number) functions.Please add those related vedios as well.
Umar Qureshi (3 years ago)
Manish do you have any pl/sql videos Thanks for your videos
Suchitra Phadke (3 years ago)
Thanks A Lot !!! Liked and Shared ..
Manish Sharma (3 years ago)
+Suchitra Phadke Thanks, appreciate your efforts :)
krishna murthy (3 years ago)
Hey Manish. Your videos are very clear to understand and thank your efforts Please post the oracle sql interview point questions with answers for various scenarios
Mukthar Baba (4 years ago)
Manish we r earegly waiting for Oracle Architecture videos like Data files,Control files, Redo log files, SGA, PGA, Processes.....etc. We hope as early as possible u will upload them. Once again thank U yar for helping us.   
Mukthar Baba (4 years ago)
Hai Manish,                 Ur videos r very useful to us. Thank U yar. 

Would you like to comment?

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