Decode and Case

What is the difference between Decode and Case with examples?

Showing Answers 1 - 2 of 2 Answers


  • Apr 8th, 2016

Decode is used in a select statement where as case is a independent statement which occur in where clause.
decode is used for static value but we can use the case for range and can enable complex business logic.
Case is faster than decode.

  Was this answer useful?  Yes


  • Oct 4th, 2017

decode is a function I used it way back in Oracle 6 and 7. Slower than Case.
Case is statement I think it is introduced in 9i, you can use Case instead of Decode, I feel Case is faster when compared to Decode as it jumps to end when condition is met and simpler to understand

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions