VAIBHAV GUPTA

• 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.

Manohar

• 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