What is the difference between decode and case 

Today I have faced interview and they have asked this question as well... Luckily I saw this video, before interview and immediately I have answered...Thanks A Lot dear for posting such a useful video... YOU WILL BE THERE IN EVERY CANDIDATE'S SMILE, WHEN THEY GET OFFER....

Sir, thanks for the video.its helps alot.. Please post the query how to update 3 rows at one time with using decode and case clause.

Can decode work with other datatype then String ?

Please make few videos on debugging ora errors by making anonymous block

null=null is true when use decode function and it is false when use case statement

Start 0:09 - Decode and Case 0:45 - Understand Using Examples 2:00 - Same Thing Using Case Statement 2:45 - To Print Pass or Fail 4:01 - Exactly Same Functionality from Case statement 5:38 - Let us see with one more example 6:40 - Few more differences now 8:26 - Few More Example 9:25 - One more difference

How we can define parenthesis for each statement I have lot of confusion in defining parenthesis I.e,(commas,double quotes,colons,square brackets etc)

Hi sir, Thanks for uploading videos! could please help me on 1)How pipeline function will work 2)How to make the non partitioned table into to partitioned 3)How select * from emp (How internally worked (Capgemini asking)) 4)Performance tunning related real time eg we want 5) Different pragmas in oracle 6) can we create index on view 7)can we create index on Materialized view 8)Can we create trigger insdide the procedure or can we create the procedure inside the trigger 9)How to calculate age of the person

Do we have any limit for decofe

Pls explain the procedure in pragma autonomous transaction in plsql

if else, case bit more advance

Hi Sir Thank you for uploading useful videos like these Sir Can you please help to answer the below question... 1.How to debug the code??

Could u pls make a video on clustered index and non clustured index if already exity pls share link

Hi sir, when you use case in plsql in the declare section for variable you assigned value 'P' only but in the execution asking when 'F' then fail..... how it will work please explain

Hi, Can you please post the local index and global index

Thankuuu so much sir...u r doing great thing :)

Hi Sir, could u pls make a video on dirty read problem and their solution

what about sql psql online classes plan shiva sir ..

why decode works with select statement in plsql procedure? any specific reason. how does it work internally?

Loved all your tutorial videos and the in-depth knowledge you shared.. hope you share some videos on hints.. thanks 🙏

Hi Siva, Can you answer the below sql scenario based question. Write a SQL for below scenario - Table named Departures contains departure airport codes and Table named Arrival contains arrival airport codes.A person is travelling from airport A (&&dep) to airport B (&&arr),IF both the airport codes A and B are in Departures table, query should return D-DIF both the airport codes A and B are in Arrivals table, query should return A-AIF A is in Departures and B is in Arrivals table, query should return D-AIF B is in Departures and A is in Arrivals table, query should return A-D

Hi Sir Can we use both (case ,decode ) in where clause

Decode can not be used in WHERE clause, while CASE can be, correct me if wrong.

Case & decode are like switch statement in java/c. Case allow expression evaluation

Please make a video on joining methods like hash join ,nested loop and merge join although there are so many videos on you tube but there is no sense and hard to understand

Hello sir can u make some videos realted to plsql scheduling jobs and whats the neecessity of its in real practical life?

I really like your explanation...I should have viewd your videos in past which would be have been helpful to learn....I was expecting you to say how decode perform with order by clause in this video

Which one is good in performance?

Can't we use user definedfunction decode

Sir really ur videos very useful for the interviews..keep do well...we are all supporting u

Can you please make video on Oracle server architecture with some best example

Nice Explanation

can we call procedure through decode function in oracle?-- can u please create a video on it or reply in comment

Awesome, thank you again Siva, your videos are the best! Regards, Sujaa

Can you discuss about the performance of the above functions?

Hi Sir, How to display Male and female values one by one row in a table, need 10 rows like this, please advice with query

Very good explanation. I never got such examples. Keep it up bro

Thank you sir.. explain very nicely 🙏

Hi sir your fantastic tq somuch for ur effort #deepika

excellent bro...tq and love you

thq sir nice explaination

decode can use in DML statement .

I need a queries for continuously two columns to change the data using dual

Awesome explanation.. thanks 🙏

REALLY VERY NICE VIDEO, THANKS A LOT FOR EXPLANATION DEAR

Simply superb

Excellent sir

Very nice. Thank you

Awesome explanation ... 👍

Super sir

Good information Provided

Hi sir. Fantastic video. Thank you . 1) How to find current week number?

fantastic job!

Hi Siva, today in the interview they asked me that what if they dont want to use any of them,any substitute for case/decode?