Difference between Case and Decode

Опубликовано: 07 Октябрь 2024
на канале: Kishan Mashru

22,296

293

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 :    • DIFFERENCE BETWEEN CHAR AND VARCHAR2 ...
replace and translate :    • Difference between Replace and Transl...
procedure and function :    • Difference between Procedure and Func...
in and exists :    • IN VS EXISTS VS JOIN, performance
rank and dense_rank :    • Row Number Vs Rank Vs Dense Rank
delete and truncate :    • Difference between Delete and Truncat...
%type and %rowtype :    • What is %type and %rowtype variable i...