HomeНаука и техникаRelated VideosMore From: Kishan Mashru

Difference between Case and Decode

127 ratings | 11461 views
This video tutorial explains on how case statement and decode function are different from each other. Though both of them are used in giving the if-then-else conditional functionality to sql statement, they differ much from each other, this video will walk through each of the difference with appropriate examples. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE procedure and function : https://youtu.be/q3LmOenL120 in and exists : https://youtu.be/REX4IjRYlFw rank and dense_rank : https://youtu.be/WGSX998hZ9M delete and truncate : https://youtu.be/u76wMm2byXo %type and %rowtype : https://youtu.be/MlLUFeZ_3eM
Html code for embedding videos on your blog
Text Comments (24)
ramesh y (9 months ago)
Hello, " SELECT CASE WHEN null IS null THEN 'True' ELSE 'False' END FROM dual" this select also gives True only. I liked the video Kishan :)
Ramesh Thamizhselvan (1 year ago)
superb bro
Kishan Mashru (1 year ago)
Thanks Bro, hope you have liked the video :)
Naga Raju (1 year ago)
Good.. plz explain normalisation
Kishan Mashru (1 year ago)
Sure, was planning to make a video on normalization!!!
Naresh AR (1 year ago)
make a video on NVL function as well
Naresh AR (1 year ago)
Thx for brief explanation! as well as can you please make a video on complex query on decode
aniruddha aswale (1 year ago)
very useful information kishan bro :) hope you remember me.. RDB team member. please send me your YouTube channel link if there is. for more information of oracle plsql . id :- [email protected]
Kishan Mashru (1 year ago)
Hey aniruddha, long time bro!!! For the youtube channel link you can log on to www.youtube.com/c/kishanmashru
shruti Rajauria (1 year ago)
highly informative video. please upload more video.
Kishan Mashru (1 year ago)
Sure!!! Thanks :)
rajesh komma (1 year ago)
thank you so much..
Kishan Mashru (1 year ago)
Welcome :) Hope you have given the video a "thumbs up"
Umakanth Kulkarni (1 year ago)
very good video,pls upload some video on colasc and null difference
Kishan Mashru (1 year ago)
Thanks man!!! Here you can have a look at the video on COALESCE https://youtu.be/0Fgsrypnxso I have uploaded videos on NVL, NVL2, NULLIF also, give them a try will be worth your time :)
prasad boppana (1 year ago)
good explanation & would we make video on normalization also
Kishan Mashru (1 year ago)
Yup, will upload it soon :)
jamsheer kutty (1 year ago)
nicely explained bro...keep up the good work :)
jamsheer kutty (1 year ago)
Kishan Mashru : yup already done bro :)
Kishan Mashru (1 year ago)
Thanks bro, I am glad you enjoyed it!!! Hope you have subscribed to our channel and liked the video :)
krishna sai (1 year ago)
good explanation bro I need more videos like this
Kishan Mashru (1 year ago)
Thanks krishna :) If you are looking for a specific topic that you didn't find on our channel, please do let me know, I'll make it. Hope you have liked the video and subscribed to our channel to get all the updates!!!
bala oracle (1 year ago)
Good explanations. please try to do some other videos . pl/sql interview questions
Kishan Mashru (1 year ago)
bala oracle thanks man!!! hope u have subscribed to our channel to get all updates, and ya am working on the same, will list out videos on plsql interview questions soon

Would you like to comment?

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