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

preview_player
Показать описание
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

--------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the first one to see my videos!
--------------------------------------------------------------------------

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

You can also Email me at

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Рекомендации по теме
Комментарии
Автор

Awesome...The great thing about U is to make short tutorials still concept is Crystal clear..!!Thanks a ton!!

likithagunda
Автор

Thank you so much for this video. It's really helpful.

bettythomas
Автор

Hai Manish,

                Ur videos r very useful to us. Thank U yar. 

muktharbaba
Автор

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

krishnamv
Автор

Manish we r earegly waiting for Oracle Architecture videos like Data files, Control files, Redo log files, SGA, PGA, We hope as early as possible u will upload them.


Once again thank U yar for helping us.
  

muktharbaba
Автор

nice tutorial, but thank good for playback speed function.

Mememeep
Автор

Manish, please upload vedio for Using DECODE funtion to test for a value < or > or = .

syedsabeer
Автор

Nice explanation... Can u pls explan slowly

chll
Автор

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.

rameshg
Автор

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

parteharsh
Автор

What would the preexisting table have to contain in order for the "Sorry" to be returned in the results?

blink_atx
Автор

How to apply decode based on multiple columns?

abhijitjadhav
Автор

Manish do you have any pl/sql videos Thanks for your videos

umarq