Is Decode() the most efficient?

I have very large Decode statements in my sql. Is there anything that is more efficient?

Thanks!

Try CASE statement, it is easier to understand and read as well.

Can anyone tell me the difference between DECODE and CASE. Which is better. i suggest CASE. is it right?

Quote:

---

Originally Posted by srikanth.mss

Can anyone tell me the difference between DECODE and CASE. Which is better. i suggest CASE. is it right?

---

There are no differences between DECODE and CASE. Remember for future that you can not use DECODE() in PL/SQL, but CASE.

regarding performance oriented, is there any difference.

I think CASe has the ability to check the ranges.